插入:
实体或者MODEL,model
model.Name="aaaaa";string query = "INSERT INTO 表名(Name)VALUES(@name)";
//对对象进行操作
conn.Execute(query, model);
//直接赋值操作
conn.Execute(query, new {name = "aaaa"});
更新:
string query = "UPDATE Book SET Name=@name WHERE id =@id";
conn.Execute(query, model);
查询:
string query = "SELECT * FROM 表名";
//无参数查询,返回列表,带参数查询和之前的参数赋值法相同。
conn.Query<model>(query).ToList();
//返回单条信息
string query = "SELECT * FROM 表名WHERE id = @id";
model= conn.Query<model>(query, new { id = id }).SingleOrDefault();
带输出函数的查询:
var param = new DynamicParameters();
param.Add("@RecTotal", 0, DbType.Int32, ParameterDirection.Output);
modelList = DbConnStr.Query<model>("PC1GetChildOrgInfo", param, null, true, null, CommandType.StoredProcedure).ToList();
去输出参数值:param.Get<int>("@RecTotal")