Difference between ExecuteSqlCommand and SqlQuery in ASP.Net Entity Framework

Question

What is the difference between ExecuteSqlCommand vs SqlQuery What is the best option to use on which condition

nagaraju60 · Accepted Answer

Dear raniPlease refer below referencehttpsstackoverflowcomquestions24248307whatisthedifferencebetweenexecutesqlcommandvssqlquerywhendoingadba

dharmendr · Answer

Hi raniExecuteSqlCommand and SqlQuery both allow to use Entity Framework to execute raw SQL queriesGenerally the SqlQuery method is used for actual queries where you expect data to be returned ie SELECT statements and SqlCommands are going to be more commonly used for nonqueries ie Insert Update and DeleteThe ExecuteSqlCommand method will return the number of rows affected by the query whereas SqlQuery returns a value of any type a collection of entities or objects for the given queryExampleSqlQueryvar customers  ContextCustomersSqlQuery34SELECT  FROM Customers34ToListExecuteSqlCommandvar rowsAffected  ContextDatabaseExecuteSqlCommand34INSERT INTO Customers Name VALUES 39Dharmendra39

Difference between ExecuteSqlCommand and SqlQuery in ASP.Net Entity Framework

Company

Explore

Follow us

Contact Us