MySQL –>EF edmx(Model First)–> Sql Server table

• 一、mysql environment

When we create an new database,first We need draw er diagram for somebody to show your idea,but our company have no good

 authorised tool to design sqlserver ER diagram,so I use mysql graphical tool to design it, after that,you can use mysql to create edmx

us entityframwork,and use this edmx to create new sqlserver database or table.The following is details:

1、first you need install mysql,the download address is http://dev.mysql.com/downloads/windows/installer/,this version is no need to install,

after that,you need install mysql,the install detail and config,you can see the article.

http://laizetian.blog.51cto.com/10728827/1786180,

for operating mysql database conviniently,you can download grapahics tool workbencn

https://dev.mysql.com/downloads/workbench/.

after you create new datatable use mysql.

二、EntityFrameWork 6.0.0.0 connect Mysql to create EF

you can folling the article to install http://www.cnblogs.com/dunitian/p/4755585.html

note:(1)you need install MySQL for Visual Studio and Connector/Net correctly,otherwise you will happen some terrible,

for example;you will not find  mysql Databse option。

 

(2)if you have isntall ef,but don't find  ADO.Net entity Data Model,maybe you have make something wrong,you

can uninstall Entity framework at control panel and reinstall it.

 

三、EF edmx create sqlserver database。

1、you can use Generate Database from Model to create sqlserver table

2、change connection Type to Sql server  and connect to database you want to create table

 

2、Next you will meet the following error

you need change edmx file xml,click right mouse on edmx file,and you will find the following and

edit。

use

<Schema Namespace="RightsDataModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">

replace <Schema Namespace="mydbModel.Store" Provider="MySql.Data.MySqlClient" ProviderManifestToken="5.7" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">

after that,you build project,you will find the following error,you need delete Precision and rebuild again.

If you want define table column type,you can define at this palce,and it will affect database table type。

After that,you can use Generate Database from Model ，you can see the following window means

it is success,you can copy script to sqlserver studio to execute it or not。