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