Geek Answers Handbook

.NET neutral application

Many product developers want to write a .NET application that will work with any popular RDBMS, such as SQL Server, oracle, DB2, MySql. If we use the Data block, it dynamically selects the database driver (OracleClient, SQLClient or OleDBClient) based on the configuration.

However, all databases have their own SQL features. There are subtle differences that do not allow the use of the same SQL code base everywhere - function names are different, how dates are processed, different, how Identity columns are processed, etc.

You can use a third-party Data Direct product to write neutral DB code using predefined escape sequences.

Are there any tools or products from Microsoft that solve this problem?

+5
source share
3 answers

The Microsoft ADO.NET Entity Framework is an Object-Relational Mapping from Microsoft that allows you to write code that is (multiple) DB-agnostic. All major DBMSs support the Entity Framework, although for many (for example, MySQL, Postgres) you will need to download something separately from your .NET Framework installation.

. , O/RM, , SQL - DB, ( , ). O/RM , SQL.

, Entity Framework - O/RM, NHibernate, SubSonic .. , "" SQL, , ..

, , Entity Framework - O/RM,

, .NET 4.0/VS2010 Microsoft Entity Framework , . , Entity Framework DDL, . ,.NET 4.0 Entity Framework T4 Templates, , , O/RM, , ( ) , O/RM, .

+12

, SQL, ORM. , ORM -. Xtensive SQL DOM, ORM - DataObjects.Net. SQL, DOM. SQL DOM DataObjects.Net, , . , .

+2

Not directly from Microsoft. These tools are commonly called Object-Relational Mappers or Short ORMs. NHibernate, for example, is a common and widely used ORM that very closely matches your needs. Of course, there are other commercial products, such as Telerik OpenAccess ORM, DevExpress XPO or RemObjects DataAbstract, which will help you become an agnostic database.

+1
source

More articles:


All Articles