public void Delete(TextWriter writer, ITabularObjectBase tableOrView)
{
writer.WriteLine("DELETE FROM ");
WriteTableName(writer, tableOrView);
writer.WriteLine("WHERE <Conditions>");
}
public string SelectCount(ITabularObjectBase tableOrView)
{
StringWriter stringWriter = new StringWriter();
SelectCount(stringWriter, tableOrView);
return(stringWriter.ToString());
}
public string Insert(ITabularObjectBase tableOrView)
{
StringWriter stringWriter = new StringWriter();
Insert(stringWriter, tableOrView);
return(stringWriter.ToString());
}
public string Delete(ITabularObjectBase tableOrView)
{
StringWriter stringWriter = new StringWriter();
Delete(stringWriter, tableOrView);
return(stringWriter.ToString());
}
public void Select(TextWriter writer, ITabularObjectBase tableOrView)
{
writer.WriteLine("SELECT");
WriteTableColumns(writer, tableOrView);
writer.WriteLine("FROM ");
WriteTableName(writer, tableOrView);
}
public void Update(TextWriter writer, ITabularObjectBase tableOrView)
{
writer.WriteLine("UPDATE ");
WriteTableName(writer, tableOrView);
writer.WriteLine("SET ");
WriteTableColumnsForUpdate(writer, tableOrView);
writer.WriteLine("WHERE <Conditions>");
}
public ColumnBaseSchema(ITabularObjectBase table, string name, DbType dataType, string nativeType, int size, byte precision, int scale, bool allowDBNull)
{
base._Database = table.Database;
this._Parent = table;
base._Name = name;
base._DataType = dataType;
base._NativeType = nativeType;
base._Size = size;
base._Precision = precision;
base._Scale = scale;
base._AllowDBNull = allowDBNull;
}
internal void WriteTableColumns(TextWriter writer, ITabularObjectBase table)
{
int maxCol = table.Columns.Count - 1;
for (int i = 0; i < table.Columns.Count; i++)
{
writer.WriteLine("\t" + string.Concat("[", table.Columns[i].Name, "]"));
if (i < maxCol)
{
writer.Write(",");
}
}
}
internal void WriteTableColumnsForUpdate(TextWriter writer, ITabularObjectBase table)
{
int maxCol = table.Columns.Count - 1;
for (int i = 0; i < table.Columns.Count; i++)
{
DataObjectBase cs = table.Columns[i];
writer.WriteLine("\t" + string.Concat("[", cs.Name, "] = ", "<", cs.Name, cs.DataType, ">"));
if (i < maxCol)
{
writer.Write(",");
}
}
}
public void Insert(TextWriter writer, ITabularObjectBase tableOrView)
{
writer.Write("INSERT INTO ");
WriteTableName(writer, tableOrView);
writer.Write("(");
// get all columns that are "writable" including PKs that are not auto generated
WriteTableColumns(writer, tableOrView);
writer.WriteLine(")");
writer.WriteLine("VALUES");
writer.WriteLine("(");
WriteTableColumnsForInsert(writer, tableOrView);
writer.WriteLine(")");
}
internal void WriteTableName(TextWriter writer, ITabularObjectBase table)
{
writer.WriteLine("\t[{0}].[{1}].[{2}]", table.Database.Name, table.Owner, table.Name);
}
public void SelectCount(TextWriter writer, ITabularObjectBase tableOrView)
{
writer.WriteLine("SELECT COUNT(*) FROM ");
WriteTableName(writer, tableOrView);
}
public ColumnBaseSchema(ITabularObjectBase table, string name, DbType dataType, string nativeType, int size, byte precision, int scale, bool allowDBNull, List <ExtendedProperty> extendedProperties)
: this(table, name, dataType, nativeType, size, precision, scale, allowDBNull)
{
base._ExtendedProperties = extendedProperties;
}
