public static void DeleteById(this IDbCommand dbCmd, Type objectType, object id) { var modelDef = ModelDefinition.GetModelDefinition(objectType); var sql = string.Format("DELETE FROM {0} WHERE {1} = {2}", OrmLiteConfig.DialectProvider.GetQuotedTableName(modelDef), OrmLiteConfig.DialectProvider.GetQuotedColumnName(modelDef.PrimaryKey.FieldName), OrmLiteConfig.DialectProvider.GetQuotedValue(id, id.GetType())); dbCmd.ExecuteSql(sql); }
public static Object ConvertTo(this IDataReader dataReader, Type returnType) { var fieldDefs = ModelDefinition.GetModelDefinition(returnType).FieldDefinitionsArray; using (dataReader) { if (dataReader.Read()) { var row = Activator.CreateInstance(returnType); row.PopulateWithSqlReader(dataReader, fieldDefs); return(row); } return(null); } }
public static List <Object> ConvertToList(this IDataReader dataReader, Type rowType) { var fieldDefs = ModelDefinition.GetModelDefinition(rowType).FieldDefinitionsArray; var to = new List <Object>(); using (dataReader) { while (dataReader.Read()) { var row = Activator.CreateInstance(rowType); row.PopulateWithSqlReader(dataReader, fieldDefs); to.Add(row); } } return(to); }
public static Object GetByIdOrDefault(this IDbCommand dbCmd, Type returnType, object idValue) { return(FirstOrDefault(dbCmd, returnType, OrmLiteConfig.DialectProvider.GetQuotedColumnName(ModelDefinition.GetModelDefinition(returnType).PrimaryKey.FieldName) + " = {0}".SqlFormat(idValue))); }