c# - Strongly Typed DataSet with a set of TableAdapters per database provider? -

I want a firmly typed dataset with designer table adapters, but Visual Studio's dataset designer provider-specific (like SQL Server vs. MySql) code and I do not want to commit to just one provider. An ORM will help, but:

• The unit framework is only 3.5 and does not play well with the dataset, and
• does not support NHibernate SQLite.

"Datasets. Masters" has a fully designed dataset for a particular provider (like SqlClient), which includes:

< A customtable adapter component, table adapters by each designer,

• A Itable Adapter Manager interface, designer TableAdapterManager for hierarchical updates implemented by.

Everything except DataSets.MyDataSetTableAdapters namespace is "copied to a dataset" project, where all the table adapter codes (Xs : With annotation) is removed.

DataSets.MyDataSetTableAdapters with namespace, MyDataSet.xsd etc., is copied and customized in each of the "Datasets .sql clients", "Datasets.SQLite" etc. Refers to each "datasets" assembly from.

Now I must choose the correct assembly to load my ITableAdapterManager implementation, based on any given connection string. When the table schema changes, then I modify the Masters assembly, give a copy code to the production assemblies, and run some tests.

So my question: am I making this very difficult? Datasets are so standard, and the need to support many database engines through the Data Access Layer is so general, there is such a method in which copy, paste, and search & amp; To change? What do you

It can be easy to ignore the autoogenerated Use TableAdapter commands and when it is time for your CRUD operation, in this way you can use the DBPRIIFF credit commodity builder to correctly format the parameters in CRDD operations. Note that it assumes that you are not mapping complex assets and your schema will remain consistent with data providers.

If you use this technique, you have to create an Adult Class that you add to the BaseClass property on your TableAdapters an "init" -type method which overrides the connection and the people with the factory Enter, select, and update commands with (depending on the auto-generated selection command & mdash; which should most providers).