public static void QueryProcNullByReader(string PK, out bool bigIntNull, out bool intNull, out bool smallIntNull, out bool tinyIntNull, out bool dateTimeNull, out bool realNull, out bool floatNull, out bool varcharNull, out bool charNull, out bool varbinaryNull, out bool binaryNull)
{
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 = SqlQueryTestDbProxy;
using (DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
rdr.Read();
bigIntNull = rdr.IsDBNull(1);
intNull = rdr.IsDBNull(2);
smallIntNull = rdr.IsDBNull(3);
tinyIntNull = rdr.IsDBNull(4);
dateTimeNull = rdr.IsDBNull(5);
realNull = rdr.IsDBNull(6);
floatNull = rdr.IsDBNull(7);
varcharNull = rdr.IsDBNull(8);
charNull = rdr.IsDBNull(9);
varbinaryNull = rdr.IsDBNull(10);
binaryNull = rdr.IsDBNull(11);
}
}
cmd.Parameters.Clear();
cmd.Dispose();
}
public static void QueryTextNullByReader(string PK, out bool bigIntNull, out bool intNull, out bool smallIntNull, out bool tinyIntNull, out bool dateTimeNull, out bool realNull, out bool floatNull, out bool varcharNull, out bool charNull, out bool varbinaryNull, out bool binaryNull)
{
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("SELECT * FROM TestDbProxy WHERE PK = '{0}'", PK);
using (DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
rdr.Read();
bigIntNull = rdr.IsDBNull(1);
intNull = rdr.IsDBNull(2);
smallIntNull = rdr.IsDBNull(3);
tinyIntNull = rdr.IsDBNull(4);
dateTimeNull = rdr.IsDBNull(5);
realNull = rdr.IsDBNull(6);
floatNull = rdr.IsDBNull(7);
varcharNull = rdr.IsDBNull(8);
charNull = rdr.IsDBNull(9);
varbinaryNull = rdr.IsDBNull(10);
binaryNull = rdr.IsDBNull(11);
}
}
cmd.Dispose();
}
public static void QueryProcNormalByReader(string PK, out long bigIntValue, out int intValue, out short smallIntValue, out byte tinyIntValue, out DateTime dateTimeValue, out float realValue, out double floatValue, out string varcharText, out string charText, out byte[] varbinaryStream, out byte[] binaryStream)
{
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 = SqlQueryTestDbProxy;
using (DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
rdr.Read();
bigIntValue = rdr.GetInt64(1);
intValue = rdr.GetInt32(2);
smallIntValue = rdr.GetInt16(3);
tinyIntValue = rdr.GetByte(4);
dateTimeValue = rdr.GetDateTime(5);
realValue = rdr.GetFloat(6);
floatValue = rdr.GetDouble(7);
varcharText = rdr.GetString(8);
charText = rdr.GetString(9);
varbinaryStream = (byte[])rdr.GetValue(10);
binaryStream = (byte[])rdr.GetValue(11);
}
}
cmd.Parameters.Clear();
cmd.Dispose();
}
public static void QueryTextNormalByReader(string PK, out long bigIntValue, out int intValue, out short smallIntValue, out byte tinyIntValue, out DateTime dateTimeValue, out float realValue, out double floatValue, out string varcharText, out string charText, out byte[] varbinaryStream, out 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("SELECT * FROM TestDbProxy WHERE PK = '{0}'", PK);
using (DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
rdr.Read();
bigIntValue = rdr.GetInt64(1);
intValue = rdr.GetInt32(2);
smallIntValue = rdr.GetInt16(3);
tinyIntValue = rdr.GetByte(4);
dateTimeValue = rdr.GetDateTime(5);
realValue = rdr.GetFloat(6);
floatValue = rdr.GetDouble(7);
varcharText = rdr.GetString(8);
charText = rdr.GetString(9);
varbinaryStream = (byte[])rdr.GetValue(10);
binaryStream = (byte[])rdr.GetValue(11);
}
}
cmd.Dispose();
}
