i have 2 question regarding LINQ & Entity Framework

1) how many type of technique are there to work with Entity Framework like

code first , model first & database first. am i right

please discuss about what is ode first , model first & database first concept and their differences .

2) please discuss all the points regarding the difference between LINQ & Entity Framework?

hoping to get elaborate discussion. thanks

Re: i have 2 question regarding LINQ & Entity Framework

Hi,

Code-First: Good if you already have a clear model, and the project start from scratch
Model-First: if you design entities when we work together with other team, IE: User, designer, developer, and other stake holder, like using modelling on Visual Studio, it's non technical works
Database-First: we do not have an choice when we create a project using existing database.
General: It's good to know them all, in some cases one of them is better, in other case is not.

Unfortunately I am not a good person to describe things.

c u

Re: i have 2 question regarding LINQ & Entity Framework

I forgot the second point:

mou_inn
the difference between LINQ & Entity Framework?

Based on my experience, I can not compare both of them. To me, they are diffrent things. We can use LINQ at the same time we use EF. Also we can use both SQL Command and LINQ at the same time we use EF. Using LINQ is much easier, but for bulky data it can be inefficient, we need to consider performance. Or when we general update one column on a database, we do not need to bring the data into Web Server, just send the SQL command to SQL Server and let the SQL server do the Update Command without data traffic on networks.

c u

Re: i have 2 question regarding LINQ & Entity Framework

On CF/DF/MF, see this tutorial:

http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-application

On EF vs. L2S: L2S is supported but is no longer being developed by Microsoft. EF is continuing to be improved and is the recommended choice unless you are working with a legacy system that already uses L2S.

Re: i have 2 question regarding LINQ & Entity Framework

mou_inn
2) please discuss all the points regarding the difference between LINQ & Entity Framework?

The very important point is that EF supports Many-To-ManyOne-To-One or One-to-Many relationship among tablescompared with thisLINQ only supports One-to-Many or One-To-One relationshipnot directly support Many-To-Manyso in the LINQ's diagramyou have to see two "One-To-Many" to express "Many-To-Many"

For more about thisyou can also refer this

http://stackoverflow.com/questions/8676/entity-framework-vs-linq-to-sql