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);
}
