MySQL database and PostgreSQL DAAB

The following articles mainly introduce the MySQL database and PostgreSQL DAAB. We are familiar with MySQL databases, so is PostgreSQL DAAB a bit unfamiliar? The following articles introduce PostgreSQL DAAB and MySQL.

I recently studied EntLib2.0 DAAB. One of the features of DAAB is that we don't have to worry about what the database is when writing code, that is, DAAB can be used as the database abstraction layer. But you have to have the driver of the database you want to use under this abstraction layer.

We know that there are two major open source relational databases: MySQL and PostgreSQL. Both databases now have ready-made open-source. NET Data Provider. Because Microsoft also provides the source code of EntLib2.0, it is easy for us to write their drivers under the abstraction layer like the DAAB Database Provider of SQL Server. I tried to write about it. The MySQL database is partially implemented, and PostgreSQL is not implemented at all.

The DAAB Database Provider of MySQL is implemented in addition to XmlReader. This is because of MySQL. net er is modeled after SQLServer. NET Database Provider to define the interface,. some newly added content of NET Framework 2.0 has not yet been implemented, and MySQL's support for XML is not as perfect as SQL Server.

PostgreSQL DAAB Database Provider is not fully implemented. And MySQL database. NET Database Provider is similar. PostgreSQL Npgsql does not implement the XmlRaeder function. In addition, Npgsql's NpgsqlCommand object does not inherit DbCommand, ICloneable, this causes NpgsqlCommand to fail to be forcibly converted. This causes PostgreSQL DAAB Database Provider to be unable to implement it.

Compared with MySQL and PostgreSQL's support for. NET, it seems that MySQL is better.

To solve the problem of using Entlib DAAB to access PostgreSQL, it is estimated that you may have to write an odbc daab Database Provider. I have studied ODBC. NET Database Provider, it seems that ODBC and MySQL databases are similar, in. the class library of NET Framework2.0 does not support XmlReader. It is estimated that the XmlReader part of odbc daab Database Provider still cannot be implemented.

The above content is an introduction to the MySQL database and PostgreSQL DAAB. I hope you will have some gains.