Dapper老司机教学-添加实体、更新实体

 /// <summary>
    /// 新增实体表
    /// </summary>
    /// <param name="obj"></param>
    /// <returns></returns>
    public long AddNewEntity<T>(object obj) where T : class,new()
    {

        long id = 0;
        try
        {
            using (IDbConnection conn = OpenConnection())
            {
                id = conn.Insert<T>((T)obj);

            }
        }
        catch (Exception ex)
        {

        }
        return id;
    }

    /// <summary>
    /// 新增实体表
    /// </summary>
    /// <param name="obj"></param>
    /// <returns></returns>
    public string AddNewEntityString<T>(object obj) where T : class,new()
    {

        string id = "";
        try
        {
            using (IDbConnection conn = OpenConnection())
            {
                id = conn.Insert<T>((T)obj);

            }
        }
        catch (Exception ex)
        {

        }
        return id;
    }

这个是插入实体方法：
TempLicense te = new TempLicense();
te.ID = Guid.NewGuid().ToString();
te.KeyWord =”12”;
comm.AddNewEntityString(te);

更新就是
///
/// 更新实体表
///
///
///
public bool UpdateEntity(object obj) where T : class,new()
{
bool flag = false;
try
{

            using (IDbConnection conn = OpenConnection())
            {
                conn.Update<T>((T)obj);
            }
        }
        catch (Exception ex)
        {
            flag = false;
        }
        return flag;

一样的自动适配主键，另外关于实体映射问题，需要

实体与表要一一对应
如果要加新属性就需要在实体类中
加
///
/// TempLicense：实体对象映射关系
///
[Serializable]
public class UsersEntityORMMapper : ClassMapper
{

        public UsersEntityORMMapper()
        {

            base.Table("TempLicense");

            Map(f => f.New_id).Ignore();//设置忽略

            //Map(f => f.Name).Key(KeyType.Identity);//设置主键  (如果主键名称不包含字母“ID”，请设置)      

            AutoMap();

        }

    }