水平分割数据表

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Linq.Expressions;
namespace Model
{
    public interface  ITable
    {
        int ID
        {
            get;
            set;
        }
        string Name
        {
            get;
            set;
        }
        System.Nullable<int> Age
        {
            get;
            set;
        }
    }

    public partial class TableA : ITable
    {
    }
    public partial class TableB : ITable
    {
    }
    public partial class TableC : ITable
    {
    }

    public enum TableType
    {
        TableA,
        TableB,
        TableC
    }

    // 对于3个表结构一样,编写共用的方法
    public class TableX
    {
        protected static CoreDataContext Core=new CoreDataContext();        
        public TableX(TableType tabletype)
        {
            type=tabletype;
        }
        private TableType type;
        public  IQueryable<ITable> GetList()//协变引用 
        {
           switch (type)
            {
                case TableType.TableA:
                       return Core.TableAs;
                case TableType.TableB:
                       return Core.TableBs;
                case TableType.TableC:
                       return Core.TableCs;                      
                default:
                       return null;
            }
        }

        public  ITable Get(int id)
        {
            return GetList().FirstOrDefault(o => o.ID==id);
        }
        public ITable Set(string name, int age)
        {
            ITable item;
            switch (type)
            {
                case TableType.TableA:
                    item=new TableA();
                    break;
                case TableType.TableB:
                    item=new TableB();
                    break;
                default:
                    item=new TableC();
                    break; 
            }
            item.Name=name;
            item.Age=age;
            return  item;
        }
     
        public  void Add(string name,int age)
        { 
            ITable t=Set(name, age);
            switch (type)
            {
                case TableType.TableA:                 
                     Core.TableAs.InsertOnSubmit(t as TableA);
                     break;
                case TableType.TableB:
                     Core.TableBs.InsertOnSubmit(t as TableB);
                     break;
                default:
                     Core.TableCs.InsertOnSubmit(t as TableC);
                     break;
            }
            Core.SubmitChanges();         
            
        }

        public  void Update(ITable item)
        {
            var it=Get(item.ID);
            if (it==null)
                  return;
            it.Name=item.Name;
            it.Age=item.Age;
            Core.SubmitChanges();
        }
   
        public  void Delete(int ID)
        {
            var it=Get(ID);
            if (it==null)
                return;
            switch (type)
            {
                case TableType.TableA:
                      Core.TableAs.DeleteOnSubmit(it as TableA);      
                      break;
                case TableType.TableB:
                     Core.TableBs.DeleteOnSubmit(it as TableB);
                     break;
                default:
                     Core.TableCs.DeleteOnSubmit(it as TableC);
                     break;
            }
            Core.SubmitChanges();
        }
         
    }

}

            string name="wangriqiang";
            int age=101;
            var t=new TableX(TableType.TableA);
            t.Add(name, age);

二  使用BaseRepository<T>

    public class ITableRepository<T>: BaseRepository<T> where T :class,ITable,new()
    {
    }

    public class Tablexx<T> where T:class,ITable,new()
    {
        ITableRepository<T> rep=new ITableRepository<T>();
        
        public IQueryable<ITable> GetList()
        {
            return rep.All as IQueryable<ITable>;
        }
      
        public ITable GetByID(int id)
        {
           return  rep.GetById(id);
        }

        public void DeleteByID(int id)
        {
            rep.DeleteById(id);
            rep.Save();
        }

        public void Add(ITable it)
        {   
            T t=new T();
            t.ID=it.ID;
            t.Name=it.Name;
            t.Age=it.Age;
            rep.Add(t);
            rep.Save();
        }
        public void Delete(ITable it)
        {
            rep.DeleteById(it.ID);
            rep.Save();
        }

        public void Update(ITable it)
        {
            var t=GetByID(it.ID);
            t.Name=it.Name;
            t.Age=it.Age;
            rep.Save();
        }

    }
    public class TableHelper
    {
        public static void Add(ITable it)
        {
            Call("Add", it);
        }
       
        public static void Delete(ITable it)
        {
            Call("Delete", it);
        } 
        public static void Update(ITable it)
        {
            Call("Update", it);           
        }

        public static void Call(string funcname, ITable it)
        {
            Type tabletype=it.GetType();
            var tx=typeof(Tablexx<>);
            Type constructed=tx.MakeGenericType(tabletype);
            object o = Activator.CreateInstance(constructed);
            var addmm=constructed.GetMethod(funcname);
            addmm.Invoke(o, new[] { it });
        }

    }
}