public void Parameter_ExecuteAsNull_NoErrors() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterSmallDateTime = null; Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure)); }
public void Parameter_ExecuteAsNull_NoErrors() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterUniqueIdentifier = null; Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure)); }
public void Parameter_Execute_NoErrors() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterNText = "Michael"; Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure)); }
public void Parameter_Execute_NoErrors() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterSmallInt = 653; Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure)); }
public void Parameter_Execute_NoErrors() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterTime = new TimeSpan(0, 11, 6, 10, 44); Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure)); }
public void Parameter_Execute_NoErrors() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterDateTime2 = new DateTime(1983, 11, 10); Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure)); }
public void Parameter_Execute_NoErrors() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterXml = "<Root />"; Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure)); }
public void Parameter_Execute_NoErrors() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterImage = new byte[100]; Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure)); }
public void Parameter_Execute_CorrectValueSet() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterReal = 656; var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure); Assert.AreEqual(656, result.ParameterReal); }
public void Parameter_Execute_CorrectValueSet() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterChar = "Michael"; var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure); Assert.AreEqual("Michael " /* CHAR(10) */, result.ParameterChar); }
public void Parameter_Execute_CorrectValueSet() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterSmallInt = 777; var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure); Assert.AreEqual(777, result.ParameterSmallInt); }
public void Parameter_Execute_CorrectValueSet() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterImage = GetBytes("michael rodda"); var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure); Assert.AreEqual(GetBytes("michael rodda"), result.ParameterImage); }
public void Parameter_Execute_TimeSet() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterDateTime2 = new DateTime(1983, 11, 10, 16, 30, 15); var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure); Assert.AreEqual(new DateTime(1983, 11, 10, 16, 30, 15), result.ParameterDateTime2); }
public void Parameter_Execute_CorrectValueSet() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterXml = "<Root />"; var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure); Assert.AreEqual("<Root />", result.ParameterXml); }
public void Parameter_Execute_CorrectValueSet() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterTime = new TimeSpan(0, 4, 13, 10, 44); var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure); Assert.AreEqual(new TimeSpan(0, 4, 13, 10, 44), result.ParameterTime); }
public void Parameter_Execute_CorrectValueSet() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterNText = "michael"; var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure); Assert.AreEqual("michael", result.ParameterNText); }
public void Parameter_Execute_MinutesRoundedUp() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterSmallDateTime = new DateTime(1983, 11, 10, 16, 35, 30); var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure); Assert.AreEqual(new DateTime(1983, 11, 10, 16, 36 /* rounded up as seconds passed => 30 */, 0), result.ParameterSmallDateTime); }
public void Parameter_Execute_CorrectValueSet() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterSmallDateTime = new DateTime(1983, 11, 10); var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure); Assert.AreEqual(new DateTime(1983, 11, 10), result.ParameterSmallDateTime); }
public void Parameter_Execute_CorrectValueSet() { var procedure = new AllTypesStoredProcedure(); procedure.ParameterDateTimeOffset = new DateTimeOffset(1983, 11, 11, 13, 45, 59, new TimeSpan(0, 2, 10, 0)); var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure); Assert.AreEqual(new DateTimeOffset(1983, 11, 11, 13, 45, 59, new TimeSpan(0, 2, 10, 0)), result.ParameterDateTimeOffset); }
public void Parameter_Execute_CorrectValueSet() { Guid guid = Guid.NewGuid(); var procedure = new AllTypesStoredProcedure(); procedure.ParameterUniqueIdentifier = guid; var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure); Assert.AreEqual(guid, result.ParameterUniqueIdentifier); }