using Enyim.Caching;
using Enyim.Caching.Memcached;
using MySql.Data.Entity;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;

namespace EFForMysql
{
    class Program
    {
        static void Main(string[] args)
        {
            MemcachedClient client = new MemcachedClient();//根据配置文件实例化一个mem客户端

            using(var db=new TestContext())
            {
                db.Database.CreateIfNotExists();//如果数据库不存在创建数据库
                db.Users.Add(, Email = "tom@tom.com" });
                db.Users.Add(, Email = "jim@tom.com" });//插入两条数据
                )
                {
                    Console.WriteLine("ok");//看看是否插入成功
                }
                var list = db.Users.ToList();//获取数据
                list.ForEach(o => client.Store(StoreMode.Add, o.Name, o));//将数据写入memcached缓存
            }

            User tom = client.Get("tom") as User;//取一条数据
            Console.WriteLine(tom.Email);

            List<string> names = new List<string> { "tom", "jim" };
            IDictionary<string, object> dic = client.Get(names);//一次访问获取多条数据
            foreach(var item in dic)
            {
                User u = item.Value as User;
                Console.WriteLine(u.Email);
            }

            Console.ReadKey();
        }
    }
    [DbConfigurationType(typeof(MySqlEFConfiguration))]//标记数据操作使用mysql配置类型
    public class TestContext:DbContext
    {
        public TestContext() : base("TestContext") { }
        public DbSet<User> Users { get; set; }
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);
            modelBuilder.Entity<User>().MapToStoredProcedures();
        }
    }
    [Serializable]
    public class User
    {
        public string Name { get; set; }
        public int Id { get; set; }
        public int Age { get; set; }
        public string Email { get; set; }
    }
}

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

    <!--配置enyim.com(memcached)节点-->
    <sectionGroup name="enyim.com">
      <section name="memcached" type="Enyim.Caching.Configuration.MemcachedClientSection, Enyim.Caching" />
    </sectionGroup>

  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6" />
  </startup>
  <system.data>
    <DbProviderFactories>
      <remove invariant="MySql.Data.MySqlClient" />
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>
  </system.data>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="mssqllocaldb" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.9.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d">
      </provider></providers>
  </entityFramework>

  <!--配置Mysql连接字符串-->
  <connectionStrings>
    <add name="TestContext" providerName="MySql.Data.MySqlClient"
          connectionString="server=192.168.0.103;port=3306;database=TestContext;uid=ted;password=150"/>
  </connectionStrings>

  <!--memcached相关配置及服务地址-->
  <enyim.com protocol="Binary">
    <memcached>
      <servers>
        <!--有多服务器时，可相同方式进行多配置-->
        <add address=" />
      </servers>
       <socketPool minPoolSize=" connectionTimeout="00:00:10" deadTimeout="00:02:00" />
    </memcached>
  </enyim.com>

</configuration>