Our Training Programs

All contents are copyright of their authors.

Enitity framework6

Enitity framework6

Ravi Patel

11yAsked Jul 15, 2015, 6:48 AM844.NET

I am new to entity framework. Usually I have been using SQL Server stored procedure and make call using ADO.NET.

Now, I want to choose what is best to use as data access layer.

Is stored procedure with entity framework good design ? or have to do linq queries on model directly (no stored procedure). ?

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Rajeesh Menoth11y ago
Hi,

Based on your situation you can choose any of them.

Important links..

1) http://www.dotnet-tricks.com/Tutorial/entityframework/1M5W300314-Difference-between-LINQ-to-SQL-and-Entity-Framework.html

2) http://www.dofactory.com/topic/1077/when-to-use-linq-to-sql-versus-entity-framework.aspx

3) http://www.c-sharpcorner.com/Blogs/48844/
Sujeet Suman11y ago
Ravi both having advantages & disadvantages. Choice should be depend upon situation. Please once go through following link:

http://www.dotnet-tricks.com/Tutorial/linq/aKQY030614-Comparing-LINQ-with-Stored-Procedure.html
Shuvojit Halder11y ago
Store procedure always better than linq query.Because store procedure is pre compiled and it takes less complexity and linq- in line query takes more complexity for execution.