Example #1
0
        public void GenerateScript()
        {
            LoadData();
            var    tables = data.Select(x => x.table_name).Distinct().ToList();
            MyConn conn;

            foreach (string table in tables)
            {
                query += "\nTable " + table + " {";
                var columns = data.Where(x => x.table_name == table).ToList();
                foreach (var column in columns)
                {
                    query += "\n" + column.column_name;
                    switch (column.type_name)
                    {
                    case "nvarchar": query += " varchar"; break;

                    case "datetime2": query += " datetime"; break;

                    default: query += " " + column.type_name; break;
                    }
                    if (column.is_key)
                    {
                        query += " [pk]";
                    }
                }
                query += "\n}";

                conn         = new MyConn();
                conn.OnRead += Conn_OnRead1;
                conn.ExecQuery(MySchm.getForeignKeys(table));
            }
            System.IO.File.WriteAllText("script.txt", query + foreignKeys);
            Console.ReadLine();
        }
Example #2
0
        public void GenerateScript()
        {
            LoadData();
            var    tables = data.Select(x => x.table_name).Distinct().ToList();
            MyConn conn;

            foreach (string table in tables)
            {
                query += "\ncreate table " + table + " (";
                var columns = data.Where(x => x.table_name == table).ToList();
                int counter = 0;
                foreach (var column in columns)
                {
                    query   += "\n" + column.column_name;
                    counter += 1;
                    switch (column.type_name)
                    {
                    case "nvarchar": query += " varchar(50)"; break;

                    case "datetime2": query += " datetime"; break;

                    case "int": query += " number(10)"; break;

                    case "bit": query += " boolean"; break;

                    default: query += " " + column.type_name; break;
                    }
                    if (column.is_key)
                    {
                        query += " primary key";
                    }
                    if (!column.is_nullable)
                    {
                        query += " not null";
                    }

                    if (counter != columns.Count)
                    {
                        query += ",";
                    }
                }
                query += "\n);";

                conn         = new MyConn();
                conn.OnRead += Conn_OnRead1;
                conn.ExecQuery(MySchm.getForeignKeys(table));
            }
            System.IO.File.WriteAllText("script.txt", query + foreignKeys);
            Console.ReadLine();
        }