C# (CSharp) NoFuture.Hbm.SortingContainers StoredProcMetadata.ToHbmSql Beispiele

Beispiel #1

Datei: TestStoredProcMetadata.cs Projekt: nofuture-git/31g

        public void TestToHbmSql()
        {
            var testSubject = new NoFuture.Hbm.SortingContainers.StoredProcMetadata();
            testSubject.ProcName = "dbo.MyStoredProc";
            var testResult = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            System.Diagnostics.Debug.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [dbo].[MyStoredProc]"));

            testSubject.ProcName = "MyStoredProc";
            testResult = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            System.Diagnostics.Debug.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [MyStoredProc]"));

            testSubject.ProcName = "my.dot.schema.MyStoredProc";
            testResult = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            System.Diagnostics.Debug.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [my.dot.schema].[MyStoredProc]"));

            testSubject.ProcName = "MyStoredProc.";
            testResult = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            System.Diagnostics.Debug.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [MyStoredProc]"));

            testSubject.ProcName = ".MyStoredProc";
            testResult = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            System.Diagnostics.Debug.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [MyStoredProc]"));

            testSubject.ProcName = ".MyStoredProc.";
            testResult = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            System.Diagnostics.Debug.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [MyStoredProc]"));

            testSubject.Parameters = new List<StoredProcParamItem>
            {
                new StoredProcParamItem {ParamName = "@parameter1"},
                new StoredProcParamItem {ParamName = "@parameter2"},
                new StoredProcParamItem {ParamName = "@parameter3"}
            };

            testResult = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            System.Diagnostics.Debug.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [MyStoredProc]"));
            Assert.IsTrue(testResult.Contains(":parameter1,"));
            Assert.IsTrue(testResult.Contains(":parameter2,"));
            Assert.IsTrue(testResult.Contains(":parameter3"));
        }

Beispiel #2

Datei: TestStoredProcMetadata.cs Projekt: nofuture-git/31g

        public void TestToHbmSql()
        {
            var testSubject = new NoFuture.Hbm.SortingContainers.StoredProcMetadata();

            testSubject.ProcName = "dbo.MyStoredProc";
            var testResult = testSubject.ToHbmSql();

            Assert.IsNotNull(testResult);
            Console.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [dbo].[MyStoredProc]"));

            testSubject.ProcName = "MyStoredProc";
            testResult           = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            Console.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [MyStoredProc]"));

            testSubject.ProcName = "my.dot.schema.MyStoredProc";
            testResult           = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            Console.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [my.dot.schema].[MyStoredProc]"));

            testSubject.ProcName = "MyStoredProc.";
            testResult           = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            Console.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [MyStoredProc]"));

            testSubject.ProcName = ".MyStoredProc";
            testResult           = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            Console.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [MyStoredProc]"));

            testSubject.ProcName = ".MyStoredProc.";
            testResult           = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            Console.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [MyStoredProc]"));

            testSubject.Parameters = new List <StoredProcParamItem>
            {
                new StoredProcParamItem {
                    ParamName = "@parameter1"
                },
                new StoredProcParamItem {
                    ParamName = "@parameter2"
                },
                new StoredProcParamItem {
                    ParamName = "@parameter3"
                }
            };

            testResult = testSubject.ToHbmSql();
            Assert.IsNotNull(testResult);
            Console.WriteLine(testResult);
            Assert.IsTrue(testResult.Contains("EXEC [MyStoredProc]"));
            Assert.IsTrue(testResult.Contains(":parameter1,"));
            Assert.IsTrue(testResult.Contains(":parameter2,"));
            Assert.IsTrue(testResult.Contains(":parameter3"));
        }