public void TesVirtRpcModel_ShouldSerializeandDeserialized()
{
var virtModel = TestDataFactory.CreateVirtTpcVirtModel();
var data = JsonConvert.SerializeObject(virtModel);
JsonConvert.DeserializeObject <VirtSqlRpcModel>(data);
}
public void ExecuteNonQuery_SqlCommandWithSingleOutputParameter_ShouldMapOutputParameterValue()
{
var virtModel = TestDataFactory.CreateVirtTpcVirtModel();
var command = new ServiceVirtRecordingDbCommand();
command.CommandText = "application.CreateRoleIfNonexistent";
command.CommandType = CommandType.StoredProcedure;
var roleName = command.CreateParameter();
roleName.ParameterName = "@RoleName";
roleName.DbType = DbType.String;
roleName.Size = 50;
roleName.Direction = ParameterDirection.Input;
var roleId = command.CreateParameter();
roleName.ParameterName = "@RoleId";
roleName.DbType = DbType.Int32;
roleName.Size = 4;
roleName.Direction = ParameterDirection.Output;
command.Parameters.Add(roleName);
command.Parameters.Add(roleId);
using (var connection = new SqlConnection("server=sameerpc;database=wideworldimporters;user id=sa;password=password1234$"))
{
command.Connection = connection;
connection.Open();
//command.ExecuteNonQuery();
//Assert.InRange((int) command.Parameters["@roleId"].Value, 0, 100);
}
var param = new SqlParameter("test", SqlDbType.BigInt);
var dat = (DbParameter)param;
//command.ExecuteNonQuery();
}
