public override DataSet QueryDataSet(string query)
{
Debug.Assert(this.DbFlavor == DbFlavor.SqlCE);
if (string.IsNullOrWhiteSpace(query))
{
return(null);
}
try
{
Connect();
DataSet dataSet = new DataSet();
using (DbDataAdapter da = SqlCeFactory.CreateSqlCeDataAdapter(query, this.sqlCEConnection))
{
da.Fill(dataSet, "Results");
}
if (dataSet.Tables.Contains("Results"))
{
return(dataSet);
}
}
catch (Exception)
{
throw; // useful for setting breakpoints.
}
return(null);
}
public override object ExecuteScalar(string cmd)
{
Debug.Assert(this.DbFlavor == DbFlavor.SqlCE);
if (cmd == null || cmd.Trim().Length == 0)
{
return(null);
}
this.AppendLog(cmd);
object result = null;
try
{
Connect();
using (DbCommand command = SqlCeFactory.CreateSqlCeCommand(cmd, this.sqlCEConnection))
{
result = command.ExecuteScalar();
}
}
catch (Exception ex)
{
throw new Exception("Error executing SQL \"" + cmd + "\"\n" + ex.Message);
}
return(result);
}
public override void Upgrade()
{
string constr = GetConnectionString(true);
using (SqlCeEngine en = SqlCeFactory.CreateSqlCeEngine(constr))
{
en.Upgrade();
}
this.sqlCEConnection.Open();
}
public override void Create()
{
string connectionString = GetConnectionString(true);
if (!File.Exists(this.DatabasePath))
{
using (SqlCeEngine en = SqlCeFactory.CreateSqlCeEngine(connectionString))
{
en.CreateDatabase();
}
}
}
public override DbConnection Connect()
{
if (this.sqlCEConnection == null || this.sqlCEConnection.State != ConnectionState.Open)
{
if (!IsSqlCEInstalled)
{
throw new MoneyException(@"<Paragraph xmlns='http://schemas.microsoft.com/winfx/2006/xaml/presentation'>SQL Compact Edition is not installed, please download it from
<Hyperlink NavigateUri='http://www.microsoft.com/download/en/details.aspx?id=17876'>Microsoft Download Center</Hyperlink>
and install the version matching your operating system platform (Select <Bold>SSCERuntime_x64-ENU.exe</Bold> if you are running
a 64 bit version of windows, otherwise <Bold>SSCERuntime_x86-ENU.exe</Bold>). Then after it is installed restart the Money application.</Paragraph>");
}
string constr = GetConnectionString(true);
this.sqlCEConnection = SqlCeFactory.CreateSqlCeConnection(constr);
this.sqlCEConnection.Open();
}
return(this.sqlCEConnection);
}
public override IDataReader ExecuteReader(string cmd)
{
Debug.Assert(this.DbFlavor == DbFlavor.SqlCE);
this.AppendLog(cmd);
try
{
Connect();
using (DbCommand command = SqlCeFactory.CreateSqlCeCommand(cmd, this.sqlCEConnection))
{
return(command.ExecuteReader());
}
}
catch (Exception)
{
throw; // useful for setting breakpoints.
}
}
public override void ExecuteNonQuery(string cmd)
{
Debug.Assert(this.DbFlavor == DbFlavor.SqlCE);
if (cmd == null || cmd.Trim().Length == 0)
{
return;
}
this.AppendLog(cmd);
try
{
Connect();
using (DbCommand command = SqlCeFactory.CreateSqlCeCommand(cmd, this.sqlCEConnection))
{
command.ExecuteNonQuery();
}
}
catch (Exception)
{
throw; // useful for setting breakpoints.
}
}