Extending Entity Framework and LINQ to SQL Support in ADO.NET Data Providers for Oracle, MySQL, PostgreSQL, and SQLite
Devart
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!