How to use stored procedure in Linq-to-Entities

What's the difference between Entity Framework, LINQ to SQL, and ADO.NET with stored procedures?

Stored procedures:...(+)...Great flexibility...Full control over SQL...The highest performance available...(-)...Requires knowledge of SQL...Stored procedures are out of source control...Substantial amount of "repeating yourself" while specifying the same table and field names. The high chance of breaking the application after renaming a DB entity ...

How to map a stored procedure using DBContext in ASP.NET MVC 3 Entity Framework

Code first does not support stored procedures....You can execute scripts in a database initialiser using:...string sql = "CREATE PROCEDURE [MyProc]..."; context.Database.ExecuteSqlCommand(sql); ...You can execute procedures them from the context like so:...string command = "EXEC MyProc"; IEnumerable<T> results = context.Database.SqlQuery<T>(command...

Performance of Linq on entity framework vs SQL stored procedure

I suspect the the major performance issue is due to a major gripe of mine. Abuse of the keyword join....Due to the usage of JOIN, you are getting too many results. So you then used a DISTINCT. Worse, you did so for the outer result set, which SQL server has no index on....var brands = from b in context.Brands where (from m in context.Materials...

Why do we have to write SET FMTONLY OFF in stored procedures when using Entity Framework

I believe the reason is similar to the one for stored procedures that run from SSRS. In summary, when FMTONLY is active, your stored procedure may have some unexpected results. Hence the reason for explicitly turning it off. For details read ...Dealing with the Evil of FMTONLY from SSRS

Get return value from stored procedure using ExecuteSqlCommand (using Entity Framework)

Based on DavidG's comment:...ExecuteSqlCommand only returns values if it's the result of a select statement....If you want the return value of a stored procedure (like shown in the question), then you have to use the ...EXEC @ReturnValue = [StoredProc] @param1 ...... method as described in ...this SO answer....

Entity Framework code-first error when using stored procedure with fields that have default value

Per @CodeNotFound suggestion.... The return from the TestInsert stored procedure must return the entire result set and not just the SCOPE_IDENTITY()... Not only that but the stored procedure must contain a parameter for each "mapped" field in the entity model. ...My last line it the InsertTest stored procedure looks something like this. ...SELECT...

Begining Entity Framework 6 With ASP.Net MVC 5 Using stored procedures only Tutorial

Have you tried this link? ...http://www.c-sharpcorner.com/UploadFile/4b0136/stored-procedures-in-entity-framework-6-in-mvc-5/...In my case, I install EF from Nuget into my visual studio 2013 and create a new EF project. I setup the EF project to connect to my database and EF allow me to call all of my stored procedures in the database. Thus, I can ...

Calling Oracle stored procedure using Entity Framework with output parameter?

In this case, you shouldn't be calling:...var query = ctx.Database.SqlQuery<CmdRegisterAssetDto>(sql, projectNameParam, countryCodeParam, locationParam, assetRegisteredParam); ...But instead be calling:...var result = ctx.Database.ExecuteSqlCommand(sql, projectNameParam, countryCodeParam, locationParam, assetRegisteredParam); ...Notice that the onl...

Calling insert stored procedure using entity framework that has return parameter

What you get back from the procedure is an ...ObjectResult<T>.... In your situation simply do:...public int InsertTeam(string countryCode, string teamName, string TeamDescription, string createdBy, char isActive) { using (var mcrContext = new MCREntities()) { var result = mcrContext.InsertTeam(countryCode, teamName, TeamDescription,...

How to import stored procedure using code first ASP.NET MVC and Entity Framework

I usually use stored procedures in the following way:...add a EF code first migration (...https://www.entityframeworktutorial.net/code-first/code-based-migration-in-code-first.aspx...) ...add the stored procedure to your migration through ...Sql()...configure the stored procedure with the model builder or in your entity...use it in your code :-)...