C# (CSharp) AllTypesStoredProcedure示例

示例#1

文件： ParameterDateTime2Tests.cs 项目： yumeizhang/EntityFrameworkExtras

        public void Parameter_ExecuteAsNull_NoErrors()
        {
            var procedure = new AllTypesStoredProcedure();
            procedure.ParameterDateTime2 = null;

            Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
        }

示例#2

文件： ParameterNvarCharTests.cs 项目： yumeizhang/EntityFrameworkExtras

        public void Parameter_Execute_NoErrors()
        {
            var procedure = new AllTypesStoredProcedure();

            procedure.ParameterNvarChar = "Michael";

            Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
        }

示例#3

        public void Parameter_Execute_NoErrors()
        {
            var procedure = new AllTypesStoredProcedure();

            procedure.ParameterTime = new TimeSpan(0, 11, 6, 10, 44);

            Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
        }

示例#4

        public void Parameter_Execute_NoErrors()
        {
            var procedure = new AllTypesStoredProcedure();

            procedure.ParameterVarBinary = new byte[100];

            Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
        }

示例#5

文件： ParameterDateTimeTests.cs 项目： yumeizhang/EntityFrameworkExtras

        public void Parameter_Execute_NoErrors()
        {
            var procedure = new AllTypesStoredProcedure();

            procedure.ParameterDateTime = new DateTime(1983, 11, 10);

            Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
        }

示例#6

        public void Parameter_Execute_NoErrors()
        {
            var procedure = new AllTypesStoredProcedure();

            procedure.ParameterUniqueIdentifier​​ = new Guid();

            Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
        }

示例#7

文件： ParameterBitTests.cs 项目： yumeizhang/EntityFrameworkExtras

        public void Parameter_Execute_NoErrors()
        {
            var procedure = new AllTypesStoredProcedure();

            procedure.ParameterBit = true;

            Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
        }

示例#8

文件： ParameterDateTime2Tests.cs 项目： yumeizhang/EntityFrameworkExtras

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

示例#9

文件： ParameterDecimalTests.cs 项目： yumeizhang/EntityFrameworkExtras

        public void Parameter_Execute_CorrectValueSet()
        {
            var procedure = new AllTypesStoredProcedure();
            procedure.ParameterDecimal = 56m;

            var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);

            Assert.AreEqual(56m, result.ParameterDecimal);
        }

示例#10

        public void Parameter_Execute_CorrectValueSet()
        {
            var procedure = new AllTypesStoredProcedure();

            procedure.ParameterXml = "<Root />";

            var result = ExecuteStoredProcedureSingle <AllTypesStoredProcedureReturn>(procedure);

            Assert.AreEqual("<Root />", result.ParameterXml);
        }

示例#11

文件： ParameterBitTests.cs 项目： yumeizhang/EntityFrameworkExtras

        public void Parameter_Execute_CorrectValueSet()
        {
            var procedure = new AllTypesStoredProcedure();

            procedure.ParameterBit = true;

            var result = ExecuteStoredProcedureSingle <AllTypesStoredProcedureReturn>(procedure);

            Assert.AreEqual(true, result.ParameterBit);
        }

示例#12

文件： ParameterSmallDateTimeTests.cs 项目： yumeizhang/EntityFrameworkExtras

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

示例#13

文件： ParameterDateTimeOffsetTests.cs 项目： zzzprojects/EntityFrameworkExtras

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

示例#14

        public void Parameter_Execute_CorrectValueSet()
        {
            var procedure = new AllTypesStoredProcedure();

            procedure.ParameterVarBinary = GetBytes("michael rodda");

            var result = ExecuteStoredProcedureSingle <AllTypesStoredProcedureReturn>(procedure);

            Assert.AreEqual(GetBytes("michael rodda"), result.ParameterVarBinary);
        }

示例#15

文件： ParameterSmallDateTimeTests.cs 项目： yumeizhang/EntityFrameworkExtras

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

示例#16

文件： ParameterNvarCharTests.cs 项目： yumeizhang/EntityFrameworkExtras

        public void Parameter_Execute_CorrectValueSet()
        {
            var procedure = new AllTypesStoredProcedure();

            procedure.ParameterNvarChar = "michael";

            var result = ExecuteStoredProcedureSingle <AllTypesStoredProcedureReturn>(procedure);

            Assert.AreEqual("michael", result.ParameterNvarChar);
        }

示例#17

文件： ParameterSmallMoneyTests.cs 项目： zzzprojects/EntityFrameworkExtras

        public void Parameter_Execute_CorrectValueSet()
        {
            var procedure = new AllTypesStoredProcedure();

            procedure.ParameterSmallMoney = 777;

            var result = ExecuteStoredProcedureSingle <AllTypesStoredProcedureReturn>(procedure);

            Assert.AreEqual(777, result.ParameterSmallMoney);
        }

示例#18

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

示例#19

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