2019年5月17日 星期五

[C#] DB data model for MySQL (Code First from database)

Create DB data model from MySQL (code first)

  1. Install NuGet packages 'MySql.Data' v.8.0.16 and 'MySql.Data.Entity' v. 6.10.8
  2. Install MySQL connector Net 6.10.8
  3. INstall MySQL for Visual Studio 1.2.8
  4. Add Entity Data Model (Code First from database)
  5. New Connection (MySQL Data Provider)
  6. Modify the file 'App.config' for DB connection string

<connectionStrings>
<add name="MySqlModel" connectionString="server=redmine2.gorilla-technology.com;user id=root;password=linuxyes;persistsecurityinfo=True;database=redmine" providerName="MySql.Data.MySqlClient" />
<add name="Default" connectionString="host=192.168.60.162;port=5432;database=redminedb;user id=redmine;password=MYSQL-TEL#53519427" providerName="Npgsql" />
</connectionStrings>


All needed works are done and then DB operations are ready to go.

using( var context = new MySqlModel() )
using( var transaction = context.Database.BeginTransaction() )
{
...
}

沒有留言:

搜尋此網誌