public string LoadTemplate <T>(DBTableAdapterContext <T> context) { var tablename = GetTableName(context.Mapping.TableName, context.Mapping.Schema); string sql = "select [" + string.Join("],[", context.AllColumns) + "] from " + tablename + " where " + string.Join(" and ", context.PkColumns.Select(i => "[" + i + "]=@" + i)); return(sql); }
public string UpdateTemplate <T>(DBTableAdapterContext <T> context) { var tablename = GetTableName(context.Mapping.TableName, context.Mapping.Schema); string sql = "update " + tablename + " set " + string.Join(",", context.SetColumns.Select(i => "[" + i + "]=@" + i)) + " where " + string.Join(" and ", context.PkColumns.Select(i => "[" + i + "]=@" + i)); return(sql); }
public string InsertTemplate <T>(DBTableAdapterContext <T> context) { var tablename = GetTableName(context.Mapping.TableName, context.Mapping.Schema); string sql = "insert into " + tablename + "([" + string.Join("],[", context.InsertColumns) + "]) values (@" + string.Join(",@", context.InsertColumns) + ")"; return(sql); }
public string UpdateTemplate <T>(DBTableAdapterContext <T> context) { var returningCols = GetReturningCols(context); string sql = "begin\r\n"; sql += "update " + GetTableName(context.Mapping.TableName, context.Mapping.Schema) + " set " + string.Join(",", context.SetColumns.Select(i => i + "=:" + i)) + " where " + string.Join(" and ", context.PkColumns.Select(i => i + "=:" + i)) + " returning " + string.Join(",", returningCols) + " into :" + string.Join(",:", returningCols) + ";\r\n"; sql += ":sql_nor := sql%ROWCOUNT;\r\n"; sql += "end;"; return(sql); }
public string InsertTemplate <T>(DBTableAdapterContext <T> context) { var returningCols = GetReturningCols(context); string sql = "begin\r\n"; sql += "insert into " + GetTableName(context.Mapping.TableName, context.Mapping.Schema) + "(" + string.Join(",", context.InsertColumns) + ") values (:" + string.Join(",:", context.InsertColumns) + ") returning " + string.Join(",", returningCols) + " into :" + string.Join(",:", returningCols) + ";\r\n"; sql += ":sql_nor := sql%ROWCOUNT;\r\n"; sql += "end;"; return(sql); }
public IDBTableAdapterCommand <T> CreateInsertCommand(DBTableAdapterContext <T> context) { var cmd = new NoQueryCommand <T>( _SqlResolver.InsertTemplate(context), context.InsertColumnsInfo.Select(i => new CommandParameter <T> { Column = i }) ); return(cmd); }
public IDBTableAdapterCommand <T> CreateInsertCommand(DBTableAdapterContext <T> context) { var cmd = new ReturningCommand <T>( _SqlResolver.InsertTemplate(context), context.AllColumnsInfo.Select(i => new CommandParameter <T> { Column = i, Direction = ParameterDirection.InputOutput }) ); return(cmd); }
public IDBTableAdapterCommand <T> CreateUpdateCommand(DBTableAdapterContext <T> context) { if (context.PkColumns.Count() == 0) { return(null); } var cmd = new NoQueryCommand <T>( _SqlResolver.UpdateTemplate(context), context.PkColumnsInfo.Concat(context.SetColumnsInfo).Select(i => new CommandParameter <T> { Column = i }) ); return(cmd); }
public IDBTableAdapterCommand <T> CreateUpdateCommand(DBTableAdapterContext <T> context) { if (context.PkColumns.Count() == 0) { return(null); } var cmd = new ReturningCommand <T>( _SqlResolver.UpdateTemplate(context), context.AllColumnsInfo.Select(i => new CommandParameter <T> { Column = i, Direction = ParameterDirection.InputOutput }) ); return(cmd); }
public string LoadTemplate <T>(DBTableAdapterContext <T> context) { string sql = "select " + string.Join(",", context.AllColumns) + " from " + GetTableName(context.Mapping.TableName, context.Mapping.Schema) + " where " + string.Join(" and ", context.PkColumns.Select(i => i + "=:" + i)); return(sql); }
private IEnumerable <string> GetReturningCols <T>(DBTableAdapterContext <T> context) { var returningCols = context.Mapping.ColumnMappingList.Where(i => i.DataType != "LONG" && i.DataType != "CLOB").Select(i => i.ColumnName); return(returningCols); }