public static void UpdateProcNull(string PK)
{
DbParameter[] parms = GetParameters();
parms[0].Value = PK;
parms[1].Value = DBNull.Value;
parms[2].Value = DBNull.Value;
parms[3].Value = DBNull.Value;
parms[4].Value = DBNull.Value;
parms[5].Value = DBNull.Value;
parms[6].Value = DBNull.Value;
parms[7].Value = DBNull.Value;
parms[8].Value = DBNull.Value;
parms[9].Value = DBNull.Value;
parms[10].Value = DBNull.Value;
parms[11].Value = DBNull.Value;
DbCommand cmd = new DbProxyCommand();
cmd.Parameters.AddRange(parms);
using (DbConnection conn = new DbProxyConnection())
{
conn.ConnectionString = proxyConnString;
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = SqlUpdateTestDbProxy;
cmd.ExecuteNonQuery();
conn.Close();
}
cmd.Parameters.Clear();
cmd.Dispose();
}
public static void UpdateProcNormal(string PK, long bigIntValue, int intValue, short smallIntValue, byte tinyIntValue, DateTime dateTimeValue, float realValue, double floatValue, string varcharText, string charText, byte[] varbinaryStream, byte[] binaryStream)
{
DbParameter[] parms = GetParameters();
parms[0].Value = PK;
parms[1].Value = bigIntValue;
parms[2].Value = intValue;
parms[3].Value = smallIntValue;
parms[4].Value = tinyIntValue;
parms[5].Value = dateTimeValue;
parms[6].Value = realValue;
parms[7].Value = floatValue;
parms[8].Value = varcharText;
parms[9].Value = charText;
parms[10].Value = varbinaryStream;
parms[11].Value = binaryStream;
DbCommand cmd = new DbProxyCommand();
cmd.Parameters.AddRange(parms);
using (DbConnection conn = new DbProxyConnection())
{
conn.ConnectionString = proxyConnString;
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = SqlUpdateTestDbProxy;
cmd.ExecuteNonQuery();
conn.Close();
}
cmd.Parameters.Clear();
cmd.Dispose();
}
public static void InsertTextNull(string PK)
{
DbCommand cmd = new DbProxyCommand();
using (DbConnection conn = new DbProxyConnection())
{
conn.ConnectionString = proxyConnString;
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = string.Format("INSERT TestDbProxy VALUES('{0}', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)", PK);
cmd.ExecuteNonQuery();
conn.Close();
}
cmd.Dispose();
}
public static void DeleteText(string PK)
{
DbCommand cmd = new DbProxyCommand();
using (DbConnection conn = new DbProxyConnection())
{
conn.ConnectionString = proxyConnString;
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = string.Format("DELETE FROM TestDbProxy WHERE PK = '{0}'", PK);
cmd.ExecuteNonQuery();
conn.Close();
}
cmd.Dispose();
}
public static void UpdateTextNull(string PK)
{
DbCommand cmd = new DbProxyCommand();
using (DbConnection conn = new DbProxyConnection())
{
conn.ConnectionString = proxyConnString;
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText =
string.Format(
"UPDATE TestDbProxy SET BigIntValue = NULL, IntValue = NULL, SmallIntValue = NULL, TinyIntValue = NULL, DateTimeValue = NULL, RealValue = NULL, FloatValue = NULL, VarcharText = NULL, CharText = NULL, VarbinaryStream = NULL, BinaryStream = NULL WHERE PK = '{0}'",
PK);
cmd.ExecuteNonQuery();
conn.Close();
}
cmd.Dispose();
}
public static void UpdateTextNormal(string PK, long bigIntValue, int intValue, short smallIntValue, byte tinyIntValue, DateTime dateTimeValue, float realValue, double floatValue, string varcharText, string charText, byte[] varbinaryStream, byte[] binaryStream)
{
DbCommand cmd = new DbProxyCommand();
using (DbConnection conn = new DbProxyConnection())
{
conn.ConnectionString = proxyConnString;
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText =
string.Format(
"UPDATE TestDbProxy SET BigIntValue = {1}, IntValue = {2}, SmallIntValue = {3}, TinyIntValue = {4}, DateTimeValue = '{5}', RealValue = {6}, FloatValue = {7}, VarcharText = '{8}', CharText = '{9}', VarbinaryStream = {10}, BinaryStream = {11} WHERE PK = '{0}'",
PK, bigIntValue, intValue, smallIntValue, tinyIntValue, dateTimeValue, realValue, floatValue,
varcharText, charText, BytesToString(binaryStream), BytesToString(varbinaryStream));
cmd.ExecuteNonQuery();
conn.Close();
}
cmd.Dispose();
}
public static void InsertTextNormal(string PK, long bigIntValue, int intValue, short smallIntValue, byte tinyIntValue, DateTime dateTimeValue, float realValue, double floatValue, string varcharText, string charText, byte[] varbinaryStream, byte[] binaryStream)
{
DbCommand cmd = new DbProxyCommand();
using (DbConnection conn = new DbProxyConnection())
{
conn.ConnectionString = proxyConnString;
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText =
string.Format(
"INSERT TestDbProxy VALUES('{0}', {1}, {2}, {3}, {4}, '{5}', {6}, {7}, '{8}', '{9}', {10}, {11})", PK,
bigIntValue, intValue, smallIntValue, tinyIntValue, dateTimeValue, realValue, floatValue,
varcharText, charText, BytesToString(binaryStream), BytesToString(varbinaryStream));
cmd.ExecuteNonQuery();
conn.Close();
}
cmd.Dispose();
}
public static void DeleteProc(string PK)
{
DbParameter parm = new DbProxyParameter("@PK", DbType.AnsiString, 50);
parm.Value = PK;
DbCommand cmd = new DbProxyCommand();
cmd.Parameters.Add(parm);
using (DbConnection conn = new DbProxyConnection())
{
conn.ConnectionString = proxyConnString;
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = SqlDeleteTestDbProxy;
cmd.ExecuteNonQuery();
conn.Close();
}
cmd.Dispose();
}
