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));
}
private DbCommand GetSQLServerCommandFromDMLScript(ISQLDMLStatement Statement)
{
DbCommand command = new SqlCommand(Statement.PreparedStatement);
if (Statement.Variables != null)
{
foreach (var variable in Statement.Variables)
{
command.Parameters.Add(new SqlParameter {
Value = variable.Value, ParameterName = variable.Name
});
}
}
return(command);
}
