Ejemplos de IRuntimeContext.CreateCommand en C# (CSharp)

Ejemplo n.º 1

Archivo: Migration23_Unicode.cs Proyecto: dradovic/MigSharp

 private static void InsertUsingParameters(IRuntimeContext ctx, string value)
 {
     IDbCommand command = ctx.CreateCommand();
     IDataParameter parameter = command.AddParameter("@value", DbType.String, value);
     command.CommandText = string.Format(CultureInfo.InvariantCulture, @"INSERT INTO ""Mig23b"" (""Data"") VALUES ({0})", ctx.ProviderMetadata.GetParameterSpecifier(parameter));
     ctx.CommandExecutor.ExecuteNonQuery(command);
 }

Ejemplo n.º 2

        private static void InsertUsingParameters(IRuntimeContext ctx, string value)
        {
            IDbCommand     command   = ctx.CreateCommand();
            IDataParameter parameter = command.AddParameter("@value", DbType.String, value);

            command.CommandText = string.Format(CultureInfo.InvariantCulture, @"INSERT INTO ""Mig23b"" (""Data"") VALUES ({0})", ctx.ProviderMetadata.GetParameterSpecifier(parameter));
            ctx.CommandExecutor.ExecuteNonQuery(command);
        }