Hi,
I want create a table using sql query in my c# application.
it is getting only odbc connection string.
obviously i can get the database provider by the odbc connection string.
i cant execute the create table query in some database.
it is throwing error.
because all the database field datatypes are not same.
example access database having text as a string type and sql server having
varchar type.
Any help would be greatly appreciated.
解决方案The only way you can have your application support multiple types of datasources is if you write the different versions of the tsql based on your target. Microsoft Access will be different than Sql which is different than MySql which is different than Oracle. They all have some different syntax rules.
I would suggest you make it a requirement that only one type of data source can be used or else you'll need to write classes for each of the types.