void IExecuteDDL.Execute(ISQLDDLStatement Statement)
{
bool returnDataSet = false;
DbConnection connection = new SqlConnection(_conn);
DbCommand command = GetSQLServerCommandFromDDLScript(Statement);
StaticDatabaseFunctions.ExecSqlCommand(connection, command, returnDataSet, null);
}
void IExecuteDDL.Execute(ISQLDDLStatement Statement)
{
bool returnDataSet = false;
DbConnection connection = new SQLiteConnection($"Data Source={_dataFile};Version=3;");
DbCommand command = GetSQLiteCommandFromDDLScript(Statement);
StaticDatabaseFunctions.ExecSqlCommand(connection, command, returnDataSet, null);
}
object IExecuteDML.Execute(ISQLDMLStatement Statement)
{
DbConnection connection = new SqlConnection(_conn);
DbCommand command = GetSQLServerCommandFromDMLScript(Statement);
bool returnDataSet = (Statement.StatemtType == DMLStatemtType.Select || Statement.StatemtType == DMLStatemtType.SelectAll);
DbDataAdapter adapter = new SqlDataAdapter((SqlCommand)command);
return(StaticDatabaseFunctions.ExecSqlCommand(connection, command, returnDataSet, adapter));
}
object IExecuteDML.Execute(ISQLDMLStatement Statement)
{
DbConnection connection = new SQLiteConnection($"Data Source={_dataFile};Version=3;");
DbCommand command = GetSQLLiteCommandFromDMLScript(Statement);
bool returnDataSet = (Statement.StatemtType == DMLStatemtType.Select) || (Statement.StatemtType == DMLStatemtType.SelectAll);
var adapter = new SQLiteDataAdapter((SQLiteCommand)command);
return(StaticDatabaseFunctions.ExecSqlCommand(connection, command, returnDataSet, adapter));
}