private static void Test() { string connectionString = "Server=(localdb)\\ProjectsV14;Database=Sample;Trusted_Connection=True;MultipleActiveResultSets=true"; var sqlJsonConverter = new SqlServerJsonConverter(connectionString); var tableNames = sqlJsonConverter.GetAllTableNames(); foreach (var tableName in tableNames) { Console.WriteLine(tableName); } //Console.WriteLine(sqlJsonConverter.GetTableRecords(tableNames[0]).GetHashCode()); File.WriteAllText("test_table_combined.json", sqlJsonConverter.GetTableRecordsJson(tableNames[0])); }
private static void Run() { Console.Write("Enter DB Connection String: "); var connectionString = Console.ReadLine(); var sqlJsonConverter = new SqlServerJsonConverter(connectionString); Console.WriteLine("Database Tables: "); var tableNames = sqlJsonConverter.GetAllTableNames(); var tableNamesDictionary = new Dictionary <int, string>(); int count = 0; foreach (var tableName in tableNames) { count++; Console.WriteLine($"\t{count}. {tableName}"); tableNamesDictionary.Add(count, tableName); } Console.Write("Please choose table: "); int choosedTable = int.Parse(Console.ReadLine()); Console.WriteLine($"Choosed table: {tableNamesDictionary[choosedTable]}"); Console.WriteLine($"Please choose operation: "); Console.WriteLine("\t1. Get sql table scheme in json format"); Console.WriteLine("\t2. Get sql table records in json format"); Console.WriteLine("\t3. Get sql table scheme and records (combined) in json format"); int choosedOperation = int.Parse(Console.ReadLine()); Console.Write("Please enter output json file name: "); var outputFileName = Console.ReadLine(); switch (choosedOperation) { case 1: { var tableSchemeJson = sqlJsonConverter.GetTableJsonScheme(tableNamesDictionary[choosedTable]); File.WriteAllText(outputFileName, tableSchemeJson); break; } case 2: { var recordsJson = sqlJsonConverter.GetRecordsJson(tableNamesDictionary[choosedTable]); File.WriteAllText(outputFileName, recordsJson); break; } case 3: { var tableRecordsJson = sqlJsonConverter.GetTableRecordsJson(tableNamesDictionary[choosedTable]); File.WriteAllText(outputFileName, tableRecordsJson); break; } default: { Console.WriteLine("Invalid input"); break; } } Console.WriteLine($"All operations finished and saved to file {outputFileName}"); }