CODEWITHSUNDEEP
entity-framework-6
Shinichi
Shinichi

Reputation: 505

Entity Framework 6: Change Sqlite to MSSQL/MySql in future without modify code?

The first, forgive me if the question is ... stupid.

I developing a winform app that use Entity Framewwork 6. Database now is Sqlite. In future, may be the database will change to MSSQL or MySql.

Is this possible ? If the anwser is yes, how I will do that ?

Thanks !

Upvotes: 2

Views: 512

Answers (1)

Jon Ryan
Jon Ryan

Reputation: 1637

Yes it is possible. You just need the right data provider installed and the correct connection string configured.

You can read about all the available providers as part of Microsoft Docs here

SQL Database (SQL, SQL Express and localdb)

Included as part of EF6. All that is needed is a change in the connection string.

MySql Database

Requires a change in the connection string and the MySql.Data.MySqlClient provider. Further information on that can be found here

Sqlite

If you are using Sqlite at the moment then you are currently using EF6 with the additional data provider System.Data.SQLite.

Upvotes: 1

Related Questions