Connect scheduler with already mysql database

Scheduler ASP.NET MVC
#1

I want to connect the scheduler with my already MySQL database but I don’t know how to connect it. Anyone help me! :smiley:

#2

Hello,
scheduler does not work with the database directly, so if you use any ORM for database access all you need to do is to set up a connection of that ORM to mysql.
If you use Entity Framework, you need to install MySQL database adapter for EF nuget.org/packages/MySql.Data.Entity/ and specify it in connection string, e.g.

<connectionStrings> <add name="MyDbContextConnectionString" providerName="MySql.Data.MySqlClient" connectionString="server=localhost;UserId=username;Password=password;database=myDatabase;CharSet=utf8;Persist Security Info=True"/> </connectionStrings>

You can also check this article on how to create model classes from existing database
dev.mysql.com/doc/connector-net … ource.html

All the rest code can be the same as in samples with MSSQL databases