public void TestUpdate()
{
var sql = DynamicQuery.GetUpdateQuery("User", new User()
{
Id = 1,
Name = "Hello world"
});
Assert.Equal("UPDATE [User] SET Name = @Name WHERE Id = @Id", sql);
}
public virtual void Update(T entity)
{
//using (IDbConnection conn = Connection)
{
var parameters = (object)Mapping(entity);
//conn.Open();
string updateQuery = DynamicQuery.GetUpdateQuery(_tableName, parameters);
SqlMapper.Execute(Connection, updateQuery, entity);
}
}
public static void Update(this IDbConnection cnn, string tableName, string primaryIdName, dynamic param)
{
SqlMapper.Execute(cnn, DynamicQuery.GetUpdateQuery(tableName, primaryIdName, param), param);
}
public static void Update(this IDbConnection cnn, string tableName, dynamic param, IDbTransaction dbTransaction = null)
{
SqlMapper.Execute(cnn, DynamicQuery.GetUpdateQuery(tableName, param), param, dbTransaction);
}
public static int DynamicQueryUpdate(this IDbConnection cnn, string tableName, object param) => SqlMapper.Execute(cnn, DynamicQuery.GetUpdateQuery(tableName, param), param);
