Exemplo n.º 1
0
    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();
          }
        }
      }
    }
    protected virtual string Execute(IQuery query,
      IDictionary<string, string> parameters, IConnectionProvider provider) {
      using (IDbConnection connection = provider.CreateConnection())
      using (var builder = new CommandBuilder(connection)) {
        builder
          .SetText(query.QueryText)
          .SetType(GetCommandType(query.Options))
          .SetTimeout(query.Options
            .GetInteger(Strings.kCommandTimeoutOption, 30));

        BindParameters(builder, query.Parameters, parameters);

        string preferred_json_collection = query.Options
          .GetString(Strings.kJsonCollectionOption,
            Strings.kDefaultJsonCollection);

        IDbCommand cmd = builder.Build();
        connection.Open();
        string response =
          (query.QueryMethod == QueryMethod.Get)
            ? ExecuteReader(cmd, query, preferred_json_collection)
            : ExecuteNonQuery(cmd, query, preferred_json_collection);
        connection.Close();
        return response;
      }
    }
Exemplo n.º 3
0
    public void Execute(string state_name, string table_name, object state) {
      using (var scope =
        new TransactionScope(SupressTransactions
          ? TransactionScopeOption.Suppress
          : TransactionScopeOption.Required)) {
        using (SqlConnection conn = sql_connection_provider_.CreateConnection())
        using (var builder = new CommandBuilder(conn)) {
          IDbCommand cmd = builder
            .SetText(@"
insert into " + table_name + @"(state_name, state)
values(@name, @state)")
            .SetType(CommandType.Text)
            .AddParameter("@name", state_name)
            .AddParameterWithValue("@state", state)
            .Build();
          try {
            conn.Open();
            cmd.ExecuteNonQuery();
            scope.Complete();
          } catch (SqlException e) {
            throw e.AsProviderException();
          }
        }
      }
    }
Exemplo n.º 4
0
    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();
        }
      }
    }
Exemplo n.º 5
0
    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();
        }
      }
    }
Exemplo n.º 6
0
 public void Execute()
 {
     using (SqlCeConnection conn = sql_connection_provider_.CreateConnection())
       using (var builder = new CommandBuilder(conn)) {
     IDbCommand cmd = builder
       .SetText(kExecute)
       .SetType(CommandType.Text)
       .Build();
     try {
       conn.Open();
       cmd.ExecuteNonQuery();
     } catch (SqlCeException e) {
       logger_.Error(
     StringResources.Log_MethodThrowsException.Fmt("Execute", kClassName),
     e);
       throw new ProviderException(e);
     }
       }
 }
Exemplo n.º 7
0
 public IHiLoRange Execute(string key) {
   using (SqlConnection conn = sql_connection_provider_.CreateConnection())
   using (var builder = new CommandBuilder(conn)) {
     IDbCommand cmd = builder
       .SetText(sql_connection_provider_.Schema + kExecute)
       .SetType(CommandType.StoredProcedure)
       .AddParameter(kKeyParameter, key)
       .Build();
     try {
       conn.Open();
       using (IDataReader reader = cmd.ExecuteReader()) {
         return mapper_.Map(reader);
       }
     } catch (SqlException e) {
       logger_.Error(string.Format(
         StringResources.Log_MethodThrowsException, "Execute", kClassName), e);
       throw new ProviderException(e);
     }
   }
 }
Exemplo n.º 8
0
 public bool Execute(out IdleTimeInfo idle_time_info)
 {
     using (SqlCeConnection conn = sql_connection_provider_.CreateConnection())
       using (var builder = new CommandBuilder(conn)) {
     IDbCommand cmd = builder
       .SetText(kExecute)
       .SetType(CommandType.Text)
       .Build();
     try {
       conn.Open();
       using (IDataReader reader = cmd.ExecuteReader()) {
     return mapper_.Map(reader, out idle_time_info);
       }
     } catch (SqlException e) {
       logger_.Error(
     StringResources.Log_MethodThrowsException.Fmt("Execute", kClassName),
     e);
       throw new ProviderException(e);
     }
       }
 }
Exemplo n.º 9
0
 public void Execute(IdleTimeInfo idle_time_info)
 {
     using (SqlCeConnection conn = sql_connection_provider_.CreateConnection())
       using (var builder = new CommandBuilder(conn)) {
     IDbCommand cmd = builder
       .SetText(kExecute)
       .SetType(CommandType.Text)
       .AddParameter("@lastInputTime", idle_time_info.LastInputTime)
       .AddParameter("@machineUpTime", idle_time_info.MachineUpTime)
       .AddParameter("@timestamp", idle_time_info.Timestamp)
       .Build();
     try {
       conn.Open();
       cmd.ExecuteNonQuery();
     } catch (SqlCeException e) {
       logger_.Error(
     StringResources.Log_MethodThrowsException.Fmt("Execute", kClassName),
     e);
       throw new ProviderException(e);
     }
       }
 }
Exemplo n.º 10
0
    /// <inheritdoc/>
    public bool GetQuery(string name, out IQuery query) {
      using (SqlConnection conn = sql_connection_provider_.CreateConnection())
      using (var builder = new CommandBuilder(conn)) {
        IDbCommand cmd = builder
          .SetText(sql_connection_provider_.Schema + kGetQuery)
          .SetType(CommandType.StoredProcedure)
          .AddParameter("@name", name, DbType.String, 260)
          .Build();

        try {
          conn.Open();
          using (IDataReader dr = cmd.ExecuteReader()) {
            query = CreateQueryFromDataReader(dr);
            return true;
          }
        } catch (SqlException e) {
          logger_.Error(
            string.Format(StringResources.Log_MethodThrowsException, kClassName,
              "GetQuery"), e);
        }
      }
      query = null;
      return false;
    }
 void BindParameters(CommandBuilder builder, IEnumerable<string> names,
   IDictionary<string, string> values) {
   foreach (string name in names) {
     string value;
     if (!values.TryGetValue(name, out value)) {
       throw new KeyNotFoundException(
         string.Format(Resources.QueryExecutor_Missing_ParameterValue, name));
     }
     builder.AddParameterWithValue(name, value);
   }
 }