Anton V. Ruzhov

Hi !
I have ADO.NET 2.0 provider for my 3rd party dbms,
I need to make it workable with Linq2SQL and Entity Framework.

I suppose, in EF there is System.Data.EntityClient namespace intended to work with DB,
but I coudnt understand how I can generate sql commands specific for other dbms.



Thanks


Re: ADO.NET (Pre-release) 3rd party ADO.NET DB provider for Linq2SQL & Entity Fw

Colin Meek - Microsoft

For information on wirting a custom provider for the Entity Framework, see David Sceppa's blog entry:

http://blogs.msdn.com/adonet/archive/2007/03/16/ado-net-orcas-sample-provider.aspx

Although LINQ to SQL does not support 3rd party providers, you can implement your own LINQ provider. See Matt Warren's series on implementing an IQueryable provider:

http://blogs.msdn.com/mattwar/archive/2007/07/30/linq-building-an-iqueryable-provider-part-i.aspx

...

Thanks,
-Colin





Re: ADO.NET (Pre-release) 3rd party ADO.NET DB provider for Linq2SQL & Entity Fw

Tim Mallalieu - MSFT

To be clear...

ADO.NET Entity Framework works on top of ADO.NET providers.

Using LINQ or ESQL with the Entity Framework is, by default, store agnostic. We hand off the query tree to the underlying provider in order to get back native SQL which we then execute against their connection. Provide writers need to implement some extra services for us in order to have this work. We are working with the major vendors to ensure that such support exists.

Tim M