public bool Execute(string name, string table_name, long state)
{
using (
new TransactionScope(SupressTransactions
? TransactionScopeOption.Suppress
: TransactionScopeOption.Required)) {
using (
SqlCeConnection conn = sql_connection_provider_.CreateConnection())
using (var builder = new CommandBuilder(conn)) {
IDbCommand cmd = builder
.SetText(@"
update " + table_name + @"
set state = @state" + @"
where name = @name
and state < @state")
.SetType(CommandType.Text)
.AddParameter("@name", name)
.AddParameterWithValue("@state", state)
.Build();
try {
conn.Open();
return(cmd.ExecuteNonQuery() > 0);
} catch (SqlCeException e) {
throw e.AsProviderException();
}
}
}
}
public bool Execute <T>(string state_name, string table_name, out T state)
{
using (
new TransactionScope(SupressTransactions
? TransactionScopeOption.Suppress
: TransactionScopeOption.Required)) {
using (
SqlCeConnection conn = sql_connection_provider_.CreateConnection())
using (var builder = new CommandBuilder(conn)) {
IDbCommand cmd = builder
.SetText("select state from " + table_name + " where name=@name")
.SetType(CommandType.Text)
.AddParameter("@name", state_name)
.Build();
try {
conn.Open();
object obj = cmd.ExecuteScalar();
if (obj == null)
{
state = default(T);
return(false);
}
state = (T)obj;
return(true);
} catch (SqlCeException e) {
logger_.Error(
StringResources.Log_MethodThrowsException.Fmt("Execute",
kClassName),
e);
throw e.AsProviderException();
}
}
}
}
public void Execute(string state_name, string table_name, object state)
{
using (
new TransactionScope(SupressTransactions
? TransactionScopeOption.Suppress
: TransactionScopeOption.Required)) {
using (
SqlCeConnection conn = sql_connection_provider_.CreateConnection())
using (var builder = new CommandBuilder(conn)) {
IDbCommand cmd = builder
.SetText(@"
insert into " + table_name + @"(name, state)
values(@name, @state)")
.SetType(CommandType.Text)
.AddParameter("@name", state_name)
.AddParameterWithValue("@state", state)
.Build();
try {
conn.Open();
cmd.ExecuteNonQuery();
} catch (SqlCeException e) {
throw e.AsProviderException();
}
}
}
}
void ExecuteInternal(string table_name, string state_type)
{
using (SqlCeConnection conn = sql_connection_provider_.CreateConnection())
using (var builder = new CommandBuilder(conn)) {
IDbCommand cmd = builder
.SetText(@"
create table " + table_name + @"(
name nvarchar(1024) unique, state " + state_type + ")")
.SetType(CommandType.Text)
.Build();
try {
conn.Open();
cmd.ExecuteNonQuery();
} catch (SqlCeException e) {
e.AsProviderException();
}
}
}
public bool Execute(string table_name)
{
using (SqlCeConnection conn = sql_connection_provider_.CreateConnection())
using (var builder = new CommandBuilder(conn)) {
IDbCommand cmd = builder
.SetText(@"
select table_name
from information_schema.tables
where table_name = @name")
.SetType(CommandType.Text)
.AddParameter("@name", table_name)
.Build();
try {
conn.Open();
return(cmd.ExecuteScalar() != null);
} catch (SqlCeException e) {
throw e.AsProviderException();
}
}
}
