Ytukyg

I have an existing application which uses mysql as database. and it's working correctly.

But now. I need to create a version of this. In-house and for home based.

My problem is when i update a feature or add a feature in the in-house program i also need to update the home based, the home based uses sqlite database.

Stored procedure doesn't work in sqlite. So idecided to use entity framework. So i can easily change database. I already create a model for one of my tables

This contains the given names for auto suggestion of my application.

And here is my class

class Given

    {

        public int id { get; set; }

        public string name { get; set; }

        public string @operator { get; set; }

        public DateTime data_time { get; set; }

    }

And i used it like this

class MyDb : DbContext

    {

        public MyDb() : base("name=sample")

        {



        }

        public DbSet<Given> tble_given { get; set; }

    }

i named it tble_given because it's the name of my table in the database

And this is my connection string in the App.config file

<connectionStrings>



    <add name="sample" providerName="MySql.Data.MySqlClient" connectionString="server=127.0.0.1; uid=root; pwd=; database=db_sample;default command timeout=20;" />

  </connectionStrings>

And this is my code for accessing the data in the database

                using (var db = new MyDb())

                {

                    db.Database.Connection.Open();

                    Debug.WriteLine(db.Database.Connection.State);

                    foreach (var item in db.tble_given.ToList())

                    {



                    }

                }

I added the connection open and the connection state in order to check if the connection is valid.

but when i query it.

added the code db.tble_given.ToList()

Exception thrown: 'System.Data.Entity.Core.ProviderIncompatibleException' in Guatemala Coding.exe
An exception of type 'System.Data.Entity.Core.ProviderIncompatibleException' occurred in Guatemala Coding.exe but was not handled in user code
An error occurred accessing the database. This usually means that the connection to the database failed. Check that the connection string is correct and that the appropriate DbContext constructor is being used to specify it or find it in the application's config file. See http://go.microsoft.com/fwlink/?LinkId=386386 for information on DbContext and connections. See the inner exception for details of the failure.

I tried solving it myself but i can't make this code work.

Why do i have this error if the connection state is open?

Thank you

For every database, there will be a separate nuget package. In your case, both of your databases might have different nuget packages. So you need to take nuget package compatible with your database.