Entity Framework连接MySQL数据库示例

一、生成Entity Framework代码

使用Entity Framework Power Tools Beta 3扩展生成EF代码:









二、Entity Framework连接MySQL数据库示例

app.config:
<?xml version="1.0"?>
<configuration>
  <connectionStrings>
    <add name="testContext" connectionString="server=localhost;user id=root;password=root123;persistsecurityinfo=True;database=test"
      providerName="MySql.Data.MySqlClient" />
  </connectionStrings>
  <startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/></startup>
</configuration>

Program.cs:
using System;
using System.Data;
using ConsoleApplication1.Models;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            using (testContext context = new testContext())
            {
                var data = context.people;
                foreach (var item in data)
                {
                    Console.WriteLine("{0},{1},{2}", item.Id, item.Name, item.Age);
                }
            }

            Console.ReadKey();
        }
    }
}



评论: 0 | 引用: 0 | 查看次数: 3096
发表评论
登录后再发表评论!