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(); }