CentOS7下安装Mysql和Memcached 以及 使用C#操作Mysql和Memcached

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>