Entity Framework连接MySQL数据库示例

<?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>

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();
        }
    }
}