public static void Delete <T>(IDictionary <string, object> conditionalEntities) { using (var con = GetSqlConnection()) { string tableName = typeof(T).Name; DbCommands.Execute( con, SqlBuilder.BuildDeleteCommand(tableName, conditionalEntities.Keys), conditionalEntities); } }
public static void Insert <T>(T entity, string[] excludeEntityNames = null) { using (var con = GetSqlConnection()) { GetProperties(entity, out string tableName, out IDictionary <string, object> properties); DbCommands.Execute( con, SqlBuilder.BuildInsertCommand(tableName, properties.Keys, excludeEntityNames), properties); } }
public static void Update <T>(T entity, IDictionary <string, object> conditionalEntities, string[] excludeEntityNames = null) { using (var con = GetSqlConnection()) { GetProperties(entity, out string tableName, out IDictionary <string, object> properties); var mergeProperties = properties; foreach (var conditionalEntity in conditionalEntities) { mergeProperties.Add("c_" + conditionalEntity.Key, conditionalEntity.Value); } DbCommands.Execute( con, SqlBuilder.BuildUpdateCommand(tableName, properties.Keys, conditionalEntities.Keys, excludeEntityNames), mergeProperties); } }