예제 #1
0
        public void TestGetStoredProcCodeGenerationMetaData()
        {
            //ASSEMBLE
            database.Refresh();
            var storedProcList = CodeGeneratorHelper.GetStoredProcedureList(database, codeGenerationSchemaName);
            var schemaName     = storedProcList[0].SchemaName;
            var storeProcName  = storedProcList[0].StoredProcName;


            //ACT
            var codeGenerationTargetMetaData = new CodeGenerationTargetMetaData
            {
                ProjectRootPath  = projectRootPath,
                ProjectName      = projectName,
                ConnectionString = connectionString,
                DatabaseName     = databaseName,
                SchemaName       = schemaName,
                StoredProcName   = storeProcName,
                NameSpace        = nameSpace
            };

            var storedProcResultSetMetaData = CodeGeneratorHelper.ProcessStoredProcedure(codeGenerationTargetMetaData);

            var methodName = storedProcResultSetMetaData.MethodName;

            //ASSERT
            Assert.IsTrue(storedProcResultSetMetaData.IsStoredProcValid);
            Assert.IsNotNull(codeGenerationTargetMetaData);
            Assert.IsNotNull(storedProcResultSetMetaData);
        }
예제 #2
0
        public void TestGetStoredProcCodeGenerationMetaDataByStoredProcName()
        {
            //ASSEMBLE
            database.Refresh();
            const string schemaName    = "API";
            const string storeProcName = "GameByGameId";
            const string assemblyPath  = @"C:\ProjectStoreGit\Solutia-MobilePatronsApp\Application\Server\MobilePatronsApp.Service\MobilePatronsApp.DataContracts\bin\Debug\MobilePatronsApp.DataContracts.dll";

            //var assemblyPath = @"C:\ProjectStoreGit\Solutia-CandidateTracking\Application\Server\CandidateTracking.DataContracts\bin\Debug\CandidateTracking.DataContracts.dll";
            byte[] data;

            using (var fs = System.IO.File.OpenRead(assemblyPath))
            {
                data = new byte[fs.Length];
                fs.Read(data, 0, Convert.ToInt32(fs.Length));
            }

            if (data == null || data.Length == 0)
            {
                throw new ApplicationException("Failed to load " + assemblyPath);
            }

            var interfaceAssembly = System.Reflection.Assembly.Load(data);

            //ACT
            var codeGenerationTargetMetaData = new CodeGenerationTargetMetaData
            {
                InterfaceAssembly = interfaceAssembly,
                ProjectRootPath   = projectRootPath,
                ProjectName       = projectName,
                ConnectionString  = connectionString,
                DatabaseName      = databaseName,
                SchemaName        = schemaName,
                StoredProcName    = storeProcName,
                NameSpace         = nameSpace
            };

            var storedProcResultSetMetaData = CodeGeneratorHelper.ProcessStoredProcedure(codeGenerationTargetMetaData);

            var methodName = storedProcResultSetMetaData.MethodName;

            //ASSERT
            Assert.IsTrue(storedProcResultSetMetaData.IsStoredProcValid);
            Assert.IsNotNull(codeGenerationTargetMetaData);
            Assert.IsNotNull(storedProcResultSetMetaData);
        }