Enitity framework6

Question

Hi All 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). ?

Rajeesh Menoth · Answer

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 Suman · Answer

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 Halder · Answer

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.

Enitity framework6

Hi All,