class EditTable : VM
    {
        public class Column
        {
            public Column(string Table, int index, string connection)
            {
                using (IDbConnection db = new SqlConnection(connection))
                {
                    IDictionary<string, object> column = db.Query($"SELECT * FROM [USUMODEL{Table}_COPY] WHERE [Порядковый номер] = {index}").Select(b => (IDictionary<string, object>)b).First();
                    this.index = index;
                    Name = column["Имя столбца"].ToString();
                    Type = column["Тип данных"].ToString();
                    Config = column["Конфигурация"].ToString();
                    IsType = (bool)column["IsType"];
                    IsDelete = (bool)column["IsDelete"];
                }
            }
            int index;
            string Name;
            string Type;
            string Config;
            bool IsType;
            bool IsDelete;
            string HelperText = "";
        };

        public RoutedCommand AddColumn;
        private string TableName;
        public List<Column> Columns = new List<Column>();
        public EditTable(string Table, string connectionString)
        {
            using (IDbConnection db = new SqlConnection(connectionString))
            {
                db.Query($"DROP TABLE IF EXISTS [{Table}_COPY]");
                db.Query($"DROP TABLE IF EXISTS [USUMODEl{Table}_COPY]");
                db.Query($"Drop TABLE IF EXISTS [SPS_COPY]");
                db.Query($"SELECT * INTO [{Table}_COPY] FROM [{Table}];");
                db.Query($"SELECT * INTO [USUMODEL{Table}_COPY] FROM [USUMODEL{Table}];");
                db.Query($"SELECT * INTO [SPS_COPY] FROM [SPS];");
                TableName = Table;
                foreach (int index in db.Query<int>($"SELECT [Порядковый номер] FROM [USUMODEL{Table}_COPY]").ToList())
                {
                    Columns.Add(new Column(Table, index, connectionString));
                }
            }
        }
    }