Mutiple-DB support with EF6 Code first and conditional column mapping.
Posted: Mon 21 Nov 2016 03:52
Hello.
I am using dotConnect for Oracle, MySQL and SQLite professional edition.
I have succeeded in supporting MSSQL, Oracle, MySQL at my web app by changing DB connection string only.
My web app was developed with EF 4.1 DB First way.
Now, I want to change EF 4.1 DB First to EF 6 code first in order to use EF6 code first auto migration feature.
I have a few questions.
1) I have implemented EF6 Code First with dotConnect for SQLite. Is it possible to support multiple DBs at the single Model of EF6 Code First by changing DB connection string only?
2) DB schema of my web app is slightly different between MSSQL and Oracle, because the length of all IDs must be equal or less than 30 in Oracle. So, I had to shorten some column names in Oracle Schema. Fortunately, I succeeded in multi-DB support by changing auto-generated model binding XML (MSL, CSDL, SSDL) of EF 4.1 DB First.
I want to change it to EF6 code first with EF code first migration feature. In order to implement it, I think that it must be possible to set conditional column name at EF6 code first or devart products, because actual DB column name mapped from a c# property is different between MSSQL and Oracle.
Is it possible to implement my requirements with devart products?
If it is possible, please let me know how I can do it.
Best regards.
I am using dotConnect for Oracle, MySQL and SQLite professional edition.
I have succeeded in supporting MSSQL, Oracle, MySQL at my web app by changing DB connection string only.
My web app was developed with EF 4.1 DB First way.
Now, I want to change EF 4.1 DB First to EF 6 code first in order to use EF6 code first auto migration feature.
I have a few questions.
1) I have implemented EF6 Code First with dotConnect for SQLite. Is it possible to support multiple DBs at the single Model of EF6 Code First by changing DB connection string only?
2) DB schema of my web app is slightly different between MSSQL and Oracle, because the length of all IDs must be equal or less than 30 in Oracle. So, I had to shorten some column names in Oracle Schema. Fortunately, I succeeded in multi-DB support by changing auto-generated model binding XML (MSL, CSDL, SSDL) of EF 4.1 DB First.
I want to change it to EF6 code first with EF code first migration feature. In order to implement it, I think that it must be possible to set conditional column name at EF6 code first or devart products, because actual DB column name mapped from a c# property is different between MSSQL and Oracle.
Is it possible to implement my requirements with devart products?
If it is possible, please let me know how I can do it.
Best regards.