Extending Entity Framework  and LINQ to SQL Support in ADO.NET Data Providers for Oracle, MySQL, PostgreSQL, and SQLite



Devart has recently announced the release of dotConnect products for
Oracle, MySQL, PostgreSQL, and SQLite ADO.NET providers that offer
Entity Framework support, LINQ to SQL support, and contain an ORM
 model designer for developing LINQ to SQL and EF models based on
different database engines.

Entity Framework support in the providers is based on the two years'
experience of working with this technology. It enables using server-
specific features like, REF CURSOR for Oracle and PostgreSQL database
engines and database specific functions for Entity SQL.

Our LINQ to Oracle, LINQ to MySQL, LINQ to PostgreSQL, LINQ to SQLite
implementation share the similar interface with the one of Micrsoft
Linq to SQL implementation and expand it by a number of options like
error processing, LoadOption on the query level (for example, query
can return child entities, if set appropriately).
Among the new features we have added expanded support for stored
procedures including out-of-order situations with REF CURSOR in Oracle
and PostgreSQL, SqlMethods class for tuning SQL queries.

With the products of the dotConnect line we provide our own designer
for modeling and code generation for ADO.NET Entity Framework and LINQ
to SQL, Entity Developer.
The key features of Entity Developer include:
Extended naming rules
Template based code generation
Visualized and on-the-fly model schema validation
Full support of stored procedures
Among the recent improvements, we have extended Entity Framework
support, added support for Entity Framework ComplexType and all three
types of inheritance, storage model became fully editable including
easy-to-use editors for DefiningQuery and CommandText.

We offer a free Express edition for each product from the dotConnect
product line.

The Single licenses start from as little as $99.95, and you can always
choose the edition that matches your needs best. To learn more,
download trial and free editions. To order a product license, please
visit Devart’s web site - www.devart.com/dotconnect/.
Feel free to write any comments and suggestions about our products!
.



Relevant Pages

  • RE: How to relate a SQL based entity with an Object based entity in Entity Framework
    ... As for "mixing the SQL and Non-SQL. ... The ADO.NET entity framework and EDM mainly focus on the object mapping ... between code level and backend database source. ... support some class/objects mapping to non-database source, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Extending SQL LINQ Table Class
    ... There are a series of LINQ to SQL articles on ScottGu's blog. ... Microsoft MSDN Online Support Lead ... Extending SQL LINQ Table Class ...
    (microsoft.public.dotnet.framework)
  • RE: Association missing in dbml generated classes
    ... How to implement a many-to-many relationship using Linq to Sql? ... Microsoft Online Community Support ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: EF or LINQtoSQL and VarBinary Max?
    ... Gregory is correct that in LINQ to SQL, ... System.Data.Linq.Binary or byte, while in LINQ to Entities, it is ... MyImageTable myImage = new MyImageTable ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Entity Framework samples files
    ... I like LINQ and Entity Framework. ... codes to query different data sources. ... Entity Framework makes the relational database into an object oriented ... Entities and LINQ to SQL, the LINQ query is translated into certain SQL ...
    (microsoft.public.dotnet.framework)