//
// SQLite query to get the list of attached databases
//
private bool IsDatabaseAttached(string dbName)
{
const string sqlAttachedDbsList = "PRAGMA database_list;";
List <string> attachedDbs = new List <string>();
SqlSelectCommand selectAttachedDbsCommand = new SqlSelectCommand(
base.Connection,
sqlAttachedDbsList,
reader =>
{
while (reader.Read())
{
string attachedDb = (reader.GetValue(1)).ToString();
attachedDbs.Add(attachedDb);
}
},
null
);
selectAttachedDbsCommand.Execute(100);
return(attachedDbs.Contains(
dbName,
StringComparer.OrdinalIgnoreCase
));
}
public DataTable[] ExecuteSql(
string sql,
IEnumerable <QueryParameterInfo> parameters,
IEnumerable <ParameterValue> parameterValues,
InstanceInfo instance
)
{
var result = new List <DataTable>();
var selectCommand = new SqlSelectCommand(
this.Connection,
sql,
reader =>
{
var table = new DataTable();
table.Load(reader, LoadOption.OverwriteChanges);
result.Add(table);
},
this.GetParameters(parameters, parameterValues, instance)
);
selectCommand.Execute(100);
return(result.ToArray());
}
