C# (CSharp) EntityFrameworkExtras.EF5.Tests.Integration.StoredProcedures AllTypesStoredProcedure示例

示例#1

文件： ParameterBinaryTests.cs 项目： ArthurYiL/EntityFrameworkExtras

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

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

示例#2

文件： ParameterRealTests.cs 项目： ArthurYiL/EntityFrameworkExtras

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

            procedure.ParameterReal = 653;

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

示例#3

文件： ParameterDateTests.cs 项目： ArthurYiL/EntityFrameworkExtras

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

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

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

示例#4

文件： ParameterBigIntTests.cs 项目： ArthurYiL/EntityFrameworkExtras

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

            procedure.ParameterBigInt = 123456789;

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

示例#5

文件： ParameterVarBinaryTests.cs 项目： ArthurYiL/EntityFrameworkExtras

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

            procedure.ParameterVarBinary = new byte[100];

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

示例#6

文件： ParameteUniqueIdentifier​​Tests.cs 项目： ArthurYiL/EntityFrameworkExtras

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

            procedure.ParameterUniqueIdentifier​​ = new Guid();

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

示例#7

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

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

            procedure.ParameterNvarChar = "Michael";

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

示例#8

文件： ParameterTimeTests.cs 项目： ArthurYiL/EntityFrameworkExtras

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

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

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

示例#9

文件： ParameterDateTests.cs 项目： ArthurYiL/EntityFrameworkExtras

        public void Parameter_Execute_NoTimeSet()
        {
            var procedure = new AllTypesStoredProcedure();
            procedure.ParameterDate = new DateTime(1983, 11, 10, 16, 30, 15);

            var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);

            Assert.AreEqual(new DateTime(1983, 11, 10, 0, 0, 0), result.ParameterDate);
        }

示例#10

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

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

            var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);

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

示例#11

文件： ParameterNTextTests.cs 项目： ArthurYiL/EntityFrameworkExtras

        public void Parameter_Execute_CorrectValueSet()
        {
            var procedure = new AllTypesStoredProcedure();
            procedure.ParameterNText = "michael";

            var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);

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

示例#12

文件： ParameterTimeTests.cs 项目： ArthurYiL/EntityFrameworkExtras

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

示例#13

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

        public void Parameter_Execute_CorrectValueSet()
        {
            var procedure = new AllTypesStoredProcedure();
            procedure.ParameterDateTime2 = new DateTime(1983, 11, 10);

            var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);

            Assert.AreEqual(new DateTime(1983, 11, 10), result.ParameterDateTime2);
        }

示例#14

文件： ParameterSmallDateTimeTests.cs 项目： ArthurYiL/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);
        }

示例#15

文件： ParameterXmlTests.cs 项目： ArthurYiL/EntityFrameworkExtras

        public void Parameter_Execute_CorrectValueSet()
        {
            var procedure = new AllTypesStoredProcedure();
            procedure.ParameterXml = "<Root />";

            var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);

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

示例#16

文件： ParameterRealTests.cs 项目： ArthurYiL/EntityFrameworkExtras

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

            var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);

            Assert.AreEqual(656, result.ParameterReal);
        }

示例#17

文件： ParameterDateTimeOffsetTests.cs 项目： ArthurYiL/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);
        }

示例#18

文件： ParameterNCharTests.cs 项目： ArthurYiL/EntityFrameworkExtras

        public void Parameter_Execute_CorrectValueSet()
        {
            var procedure = new AllTypesStoredProcedure();
            procedure.ParameterNChar = "Michael";

            var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);

            Assert.AreEqual("Michael   " /* NCHAR(10) */, result.ParameterNChar);
        }

示例#19

文件： ParameterBinaryTests.cs 项目： ArthurYiL/EntityFrameworkExtras

        public void Parameter_Execute_CorrectValueSet()
        {
            var procedure = new AllTypesStoredProcedure();
            procedure.ParameterBinary = GetBytes("michael rodda");

            var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);

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

示例#20

文件： ParameterTinyIntTests.cs 项目： ArthurYiL/EntityFrameworkExtras

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

            var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);

            Assert.AreEqual(255, result.ParameterTinyInt);
        }

示例#21

文件： ParameteUniqueIdentifier​​Tests.cs 项目： ArthurYiL/EntityFrameworkExtras

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