public void CreateClassFromSqlTableReferenceForActualUseWhenNeedingToGenerateCSharpClasses() { var sqlTableReference = new SqlTableReference(SqlConnectionProviders.PbsiCopy, "PbsiWM.MTDINV_LINE"); var sqlTable = SqlTableFactory.Create(sqlTableReference); var cSharpClass = CSharpClassGeneratorFromSqlTable.GenerateClass(sqlTable); Console.WriteLine(cSharpClass); }
public void CreateClassFromSqlTableReference() { var sqlTableReference = new SqlTableReference(SqlConnectionProviders.AdventureWorksDb, TableName); var sqlTable = SqlTableFactory.Create(sqlTableReference); var cSharpClass = CSharpClassGeneratorFromSqlTable.GenerateClass(sqlTable); Console.WriteLine(cSharpClass); }
public static string GenerateClassFromTable(this ISqlConnectionProvider sqlConnectionProvider, string schemaname, string tableName, string className = null) { className = className ?? tableName; var sqlTableReference = new SqlTableReference(sqlConnectionProvider, schemaname, tableName); var sqlTable = SqlTableFactory.Create(sqlTableReference); return(CSharpClassGeneratorFromSqlTable.GenerateClass(sqlTable, className)); }
public void CreateManyRandomClassesFromInformationSchema() { string outputText = String.Empty; var randomSqlTableReferences = RandomTableSelector.GetRandomSqlTableReferences(SqlConnectionProviders.AdventureWorksDb, 400); foreach (var sqlTableReference in randomSqlTableReferences) { var sqlTable = SqlTableFactory.Create(sqlTableReference); var cSharpClass = CSharpClassGeneratorFromSqlTable.GenerateClass(sqlTable); outputText += cSharpClass; } Console.WriteLine(outputText); }
public void TestCompilationOfManyClasses() { int errorCount = 0; int successCount = 0; IList <SqlTableReference> randomSqlTableReferences = null; "Given a list of SqlTableReferences" ._(() => { randomSqlTableReferences = RandomTableSelector.GetRandomSqlTableReferences(SqlConnectionProviders.AdventureWorksDb, 400); }); "Convert each table reference to a C# class and check for syntax errors using Roslyn" ._foreach(randomSqlTableReferences, sqlTableReference => { var sqlTable = SqlTableFactory.Create(sqlTableReference); var cSharpClass = CSharpClassGeneratorFromSqlTable.GenerateClass(sqlTable); var compileResult = RoslynHelper.TryCompile(cSharpClass); if (compileResult.IsValid()) { successCount++; } else { errorCount++; Console.WriteLine("Error found in the following:\r\n" + cSharpClass); } }); "Then print out testing results" ._(() => { Console.WriteLine("Successes: {0}", successCount); Console.WriteLine("Failures: {0}", errorCount); errorCount.Should().Be(0); }); }