RE: Entity Framework samples files

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Alex,

I am really glad to hear that you have learnt LINQ for more than half a
year. I like LINQ and Entity Framework. They are two great technologies
of Microsoft. Here are my ideas for your references:

LINQ is a SQL-styled query language used in Visual C# or VB.NET managed
codes to query different data sources. We have LINQ to Objects, LINQ to
XML, LINQ to SQL, LINQ to Entities, LINQ to DataSets, and many other LINQ
extension providers, from Microsoft or many third parties. LINQ has
provides us with a uniform standard to query different source of data. One
way, but it fits many different scenarios.

Entity Framework makes the relational database into an object oriented
model. We can perform normal CRUD operations on the database tables,
views, and call stored procedures via Entity Framework. In LINQ to
Entities and LINQ to SQL, the LINQ query is translated into certain SQL
command during runtime to query the database. So LINQ plays an important
role on query data in Entity Framework. But besides LINQ, Entity Framework
has many other important concepts and methods, like stored procedures,
Entity SQL, and EntityKey.

My suggestion:
If you are developing some websites/applications connecting to relational
database, Entity Framework can have a higher priority in your learning
plan, since you must be familiar with basic knowledge of LINQ after the
half-a-year studying.

Here are more references about Entity Framework for your references:
Stored Procedure Support (Entity Framework)
http://msdn.microsoft.com/en-us/library/bb399203.aspx

Entity SQL
http://msdn.microsoft.com/en-us/library/bb387145.aspx

Working with Entity Keys (Entity Framework)
http://msdn.microsoft.com/en-us/library/dd283139.aspx

Hope you have a nice weekend!

Best Regards,
Lingzhi Sun
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@xxxxxxxxxxxxxx

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================

.

Relevant Pages

  • Re: Are Linq-SQL methods commutative
    ... No - in LINQ each step effectively works off the result of the ... linq query which has to meet a SQL query they have in mind. ... freedom a SQL statement gives them: the SQL statement is the one ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Are Linq-SQL methods commutative
    ... because to translate what is being done in LINQ to ... of the previous query. ... the intention of the linq query with SQL. ... get 2 different resultsets by specifying them in a different order, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Building expression trees to filter derived entity classes
    ... up the inheritance correctly in your LINQ to SQL mapping? ... you project the your LINQ to SQL entity objects onto some other POCO ... LINQ to SQL is still trying to process the entire query, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Are Linq-SQL methods commutative
    ... because to translate what is being done in LINQ to database ... you would actually perform a query on the result set of the previous ... SQL Server, then the ordering of the result set will be on that index, ... But I agree with you, in database land, it makes no sense, because you ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: LINQ to SQL vs. Stored Procedures (Performance)
    ... If it is an oft used LINQ ... query, you will find that SQL Server creates stats and the query will run ... Stored Procedure and a LINQ to SQL command, ...
    (microsoft.public.dotnet.framework)