Uisng ADO.Net The Entity Framework

[John]

Hi

Is the entity framework anything that can be used in serious database
winfrom applications now? I am just not clear on that. Would appreciate some
comments on where to place EF.

Thanks

Regards

 

[Michel Posseth [MCP]]

Short answer Yes

HTH

Michel

 

[Miha Markic]

Id' wait for v2 (or actually v4 as it is named).

 

[Mary Chipman [MSFT]]

You can get a better idea of whether the EF works for you by poking
around on the forums and reading about other peoples' experience --
here's the list of all the .NET data access forums --
http://social.msdn.microsoft.com/forums/en-US/category/dataplatformdev/.
The EF forum also has links to other resources --
http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/threads.
The Data Platform Developer Center home page is where you can find
links to just about everything data related --
http://msdn.microsoft.com/en-us/data/default.aspx.

--Mary

 

[dotNetDave]

In the current version of EF, it's pretty difficult to deal with for larger
service oriented applications. But it shows a lot of promise. If you are
ready to dive in I recommend the following:

1. Get Julie Lerman's book titled "Programming Entity Framework". It's
really been a great help to me.

2. Check out my overview presentation and code at:
http://dotnettips.com/2009/06/09/PhoenixAndSanDiegoJuneCodeCamps.aspx

3. Also check out my article at:
http://dotnettips.com/2008/09/30/Wh...tTheEntityFrameworkAndADONETDataServices.aspx

David

======================================
David McCarter [Microsoft MVP]
www.dotNetTips.com
David McCarter''s .NET Coding Standards available at:
http://codingstandards.notlong.com

 

[Mr. Arnold]

In the current version of EF, it's pretty difficult to deal with for
larger
service oriented applications. But it shows a lot of promise.

EF has a lot of promise right now with the use of ESQL and Linq-2-Entities.
I am using EF with 29 entities on the Model in a WCF SOA backend solution
with no problems with object injection into a Windows Workflow, and the
objects persisting themselves to the Model. EF is a piece of cake, if one
takes the time to figure out how to use the solution. Also, with EF and
ADO.Net Data service, another from of a WCF Web service, it allows a lot of
nice things that can be done as a Linq Query service provider.



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4181 (20090623) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

 

[Eldhose]

EF has a lot of promise right now with the use of ESQL and Linq-2-Entities.
I am using EF with 29 entities on the Model in a WCF SOA backend solution
with no problems with object injection into a Windows Workflow, and the
objects persisting themselves to the Model. EF is a piece of cake, if one
takes the time to figure out how to use the solution. Also, with EF and
ADO.Net Data service, another from of a WCF Web service, it allows a lot of
nice things that can be done as a Linq Query service provider.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4181 (20090623) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Can you please say how can take data from muliple entities as a
summary view??

 

[Mr. Arnold]

EF has a lot of promise right now with the use of ESQL and
Linq-2-Entities.
I am using EF with 29 entities on the Model in a WCF SOA backend solution
with no problems with object injection into a Windows Workflow, and the
objects persisting themselves to the Model. EF is a piece of cake, if one
takes the time to figure out how to use the solution. Also, with EF and
ADO.Net Data service, another from of a WCF Web service, it allows a lot
of
nice things that can be done as a Linq Query service provider.

Can you please say how can take data from muliple entities as a
summary view??

--------------------------------------

You cannot do CURD operations with ESQL in the 3.5 Framework version, which
is coming in subsequent versions. But you can use ESQL to query Entities on
the model, with TSQL like ESQL statements.

Just about every thing you can do with TSQL to 'Select' data from SQL Server
tables, you can do with ESQL againt the Model to select data from entities
on the Model.

http://www.aspfree.com/c/a/ASP.NET/Introduction-to-the-ADONET-Entity-Framework-using-ASPNET/4/
http://msdn.microsoft.com/en-us/library/bb387145.aspx
http://msdn.microsoft.com/en-us/library/bb387118.aspx

You get the ESQL resultset back, you use ESQL's data reader to read the
resultset.

You should find a good book on how to use Entity-SQL.





__________ Information from ESET NOD32 Antivirus, version of virus signature database 4268 (20090722) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com