public SybaseDataAdapter (SybaseCommand selectCommand)
{
DeleteCommand = new SybaseCommand ();
InsertCommand = new SybaseCommand ();
SelectCommand = selectCommand;
UpdateCommand = new SybaseCommand ();
}
public SybaseDataAdapter (SybaseCommand selectCommand)
{
SelectCommand = selectCommand;
#if NET_2_0
UpdateBatchSize = 1;
#endif
}
internal SybaseDataReader (SybaseCommand command)
{
this.command = command;
schemaTable = ConstructSchemaTable ();
resultsRead = 0;
fieldCount = 0;
isClosed = false;
isSelect = (command.CommandText.Trim ().ToUpper ().StartsWith ("SELECT"));
command.Tds.RecordsAffected = 0;
NextResult ();
}
internal SybaseDataReader (SybaseCommand command)
{
readResult = false;
haveRead = false;
readResultUsed = false;
this.command = command;
resultsRead = 0;
isClosed = false;
command.Tds.RecordsAffected = -1;
#if NET_2_0
visibleFieldCount = 0;
#endif
NextResult ();
}
internal SybaseParameterCollection (SybaseCommand command)
{
this.command = command;
metaParameters = new TdsMetaParameterCollection ();
}
public static void DeriveParameters (SybaseCommand command)
{
throw new NotImplementedException ();
}
public SybaseCommand CreateCommand ()
{
SybaseCommand command = new SybaseCommand ();
command.Connection = this;
return command;
}
/// <summary>
/// Please refer to the documentation of <see cref="GentleProvider"/> and the
/// <see cref="IPersistenceEngine"/> interface it implements for details.
/// </summary>
public override IDbCommand GetCommand()
{
IDbCommand cmd = new SybaseCommand();
cmd.CommandTimeout = GentleSettings.DefaultCommandTimeout;
return cmd;
}
/// <summary>
/// Get a collection of views from the system.
/// </summary>
public override ViewSchema[] GetViews()
{
ArrayList collection = new ArrayList();
SybaseCommand command = new SybaseCommand();
command.Connection = connection;
command.CommandText =
"SELECT su.name AS owner, so.name as table_name, so.id as table_id, " +
" so.crdate as created_date, so.type as table_type " +
"FROM dbo.sysobjects so, dbo.sysusers su " +
"WHERE type = 'V' " +
"AND su.uid = so.uid " +
"ORDER BY 1, 2";
SybaseDataReader r = command.ExecuteReader();
while (r.Read()) {
ViewSchema view = new ViewSchema();
view.Provider = this;
try {
view.Name = r.GetString(1);
view.SchemaName = r.GetString(0);
view.OwnerName = r.GetString(0);
StringBuilder sb = new StringBuilder();
sb.AppendFormat ("-- View: {0}\n", view.Name);
sb.AppendFormat ("-- DROP VIEW {0};\n\n", view.Name);
string source = GetSource(view.Owner + "." + view.Name);
sb.AppendFormat (" {0}\n);", source);
view.Definition = sb.ToString ();
//view.Comment = r.GetString(5);
} catch (Exception e) {
}
collection.Add(view);
}
r.Close ();
r = null;
command.Dispose();
command = null;
return (ViewSchema[]) collection.ToArray (typeof (ViewSchema));
}
/// <summary>
/// Get a list of tables in the system.
/// </summary>
public override TableSchema[] GetTables()
{
if (IsOpen == false && Open () == false)
throw new InvalidOperationException ("Invalid connection");
ArrayList collection = new ArrayList ();
SybaseCommand command = new SybaseCommand();
command.Connection = connection;
command.CommandText =
"SELECT su.name AS owner, so.name as table_name, so.id as table_id, " +
" so.crdate as created_date, so.type as table_type " +
"FROM dbo.sysobjects so, dbo.sysusers su " +
"WHERE type IN ('S','U') " +
"AND su.uid = so.uid " +
"ORDER BY 1, 2";
SybaseDataReader r = command.ExecuteReader();
while (r.Read()) {
TableSchema table = new TableSchema();
table.Provider = this;
table.Name = r.GetString(1);
table.IsSystemTable = r.GetString(4) == "S" ? true : false;
table.SchemaName = r.GetString(0);
table.OwnerName = r.GetString(0);
table.Comment = "";
StringBuilder sb = new StringBuilder();
sb.AppendFormat ("-- Table: {0}\n", table.Name);
sb.AppendFormat ("-- DROP TABLE {0};\n\n", table.Name);
sb.AppendFormat ("CREATE TABLE {0} (\n", table.Name);
ColumnSchema[] columns = table.Columns;
string[] parts = new string[columns.Length];
for (int i = 0; i < parts.Length; i++) {
parts[i] = "\t" + columns[i].Definition;
}
sb.Append (String.Join (",\n", parts));
ConstraintSchema[] cons = table.Constraints;
parts = new string[cons.Length];
if (cons.Length > 0)
sb.Append (",\n");
for (int i = 0; i < parts.Length; i++) {
parts[i] = "\t" + cons[i].Definition;
}
sb.Append (String.Join (",\n", parts));
sb.Append ("\n);\n");
//sb.AppendFormat ("COMMENT ON TABLE {0} IS '{1}';", table.Name, table.Comment);
table.Definition = sb.ToString();
collection.Add (table);
}
r.Close ();
r = null;
command.Dispose ();
command = null;
return (TableSchema[]) collection.ToArray (typeof (TableSchema));
}
/// <summary>
/// Thread safe SQL execution.
/// </summary>
public override DataTable ExecuteSQL(string SQLText)
{
try {
SybaseCommand command = new SybaseCommand();
command.Connection = connection;
command.CommandText = SQLText;
DataSet resultSet = new DataSet ();
lock(adapter) {
adapter.SelectCommand = command;
adapter.Fill(resultSet);
}
return resultSet.Tables[0];
} catch {
return null;
}
}
