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