Пример #1
0
        static void Main(string[] args)
        {
            var dbGrout          = new DB_Grout();
            var connectionString = "Data Source=.;Initial Catalog=Grout;user id=sa;password=Admin@123";
            var dbCreationScript = File.ReadAllText("ColumnDetector.sql");
            var connection       = new SqlConnection(connectionString);

            var result = new DataTable();

            var adapter = new SqlDataAdapter(dbCreationScript, connection);

            try
            {
                adapter.Fill(result);
            }
            catch (Exception e)
            {
                throw e;
            }
            finally
            {
                adapter.Dispose();
                connection.Close();
            }

            var dataClasses = result.AsEnumerable().Select(r => r.Field <string>("query")).FirstOrDefault();

            using (TextWriter w = File.CreateText(AppDomain.CurrentDomain.BaseDirectory + "../../../Grout.Base.Data/DataBase/DB_GruntUMP.cs"))
            {
                w.WriteLine(dataClasses);
            }
        }
Пример #2
0
 public GlobalAppSettings()
 {
     DbColumns = new DB_Grout();
 }