CSharp-DBExport/Program.cs at master · ti-ka/CSharp-DBExport · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
using System;
using System.Collections.Generic;
using Utils.DbExport.Core;
using Utils.DbExport.Models;

namespace Utils.DbExport
{
    class Program
    {


        static void Main(string[] args)
        {
            var masterContextExportEngine = GetMasterSettings();
            Console.WriteLine("Press any key to export master Entites");
            Console.ReadKey();

            masterContextExportEngine.ExportTables();

            Console.WriteLine("Export Comeplete!! Press any key to exit");
            Console.ReadKey();
        }

        public static ExportEngine GetMasterSettings()
        {
            var masterSettings = new ImportSettings
            {
                ConnectionString = Constants.MasterConnectionString,
                Extend = Constants.BaseEntity,
                IgnoredColumns = (Constants.GetIgnoreColumnList()),
                NameSpace = Constants.MasterNamespaceLocation,
                OutputDirectory = Constants.MasterEntityOutputDirectory,
                EntityTemplateLocation = Constants.MasterEntityTemplateName,
                SchemaToImport = new List<string>()
                {
                    "access"
                },
                TablesToImport = new List<string>()
                {
                    "OrganizationAccessView",
                    "insights",
                    "FilterOperands",
                    "FilterEntityColumns"
                }
            };
            ExportEngine engine = new ExportEngine(masterSettings);
            engine.ApplyDefaultImportSettings();
            engine._importSettings.ImportAllTables = false;
            engine._importSettings.ImportAllSchema = false;
            return engine;
        }

        //public static SqlToCSharp GetClientSettings()
        //{
        //    var utility = new SqlToCSharp(Constants.ClientConnectionString)
        //    {
        //        Extend = Constants.BaseEntity,
        //        IgnoredColumns = (Constants.GetIgnoreColumnList()),
        //        NameSpace = Constants.ClientNamespaceLocation,
        //        OutputDirectory = Constants.ClientEntityOutputDirectory,
        //    };
        //    return utility;
        //}


        //[Obsolete("Repositories are no longer auto generated.", true)]
        //public static void WriteToMasterRepository(SqlToCSharp utility)
        //{
        //    var repository = new Repository("../Omnidek.DataLayer/MasterRepository", utility.GetAllTabel());
        //    repository.Export("master-repository", "master-repository-interface");
        //}

        //[Obsolete("Repositories are no longer auto generated.", true)]
        //public static void WriteToClientRepository(SqlToCSharp utility)
        //{
        //    var repository = new Repository("../Omnidek.DataLayer/ClientRepository", utility.GetAllTabel());
        //    repository.Export("client-repository", "client-repository-interface");
        //}
    }
}