public static int Insert <T>(this DbAccessor db, object objParameters) { var mapping = new TableMapping(typeof(T)); mapping.FilterColumn(objParameters); ISqlBuilder sqlBuilder = new DefaultSqlBuilder(mapping); return(db.ExecuteNonQuery(sqlBuilder.BuildInsert(), objParameters)); }
public void TableMapping() { TableMapping table = new TableMapping(typeof(SysProduct)); Console.WriteLine(table.TableName); foreach (var col in table.Columns) { Console.WriteLine(col.ColumnName + " " + col.IsPrimaryKey); } DefaultSqlBuilder sqlb = new DefaultSqlBuilder(table); Console.WriteLine(sqlb.BuildDelete()); Console.WriteLine(sqlb.BuildInsert()); Console.WriteLine(sqlb.BuildUpdate()); }
public static int Insert(this DbAccessor db, object objEntity) { ISqlBuilder sqlBuilder = new DefaultSqlBuilder(new TableMapping(objEntity.GetType())); return(db.ExecuteNonQuery(sqlBuilder.BuildInsert(), objEntity)); }