void test() { /*var t = TypeCreator.Creator("Qwert", 10); * object obj = Activator.CreateInstance(t); * var ps = t.GetProperties(); * ps.Where(p=>p.PropertyType == typeof(string)).ToList().ForEach(p => * { * p.SetValue(obj,"ddddddddd"); * });*/ /* * SqlServerMigrationSqlGenerator gen = new SqlServerMigrationSqlGenerator(); * * * * var operations = new List<MigrationOperation>(); * var table1 = new CreateTableOperation("fdgdg"); * var id = new ColumnModel(System.Data.Entity.Core.Metadata.Edm.PrimitiveTypeKind.Int32) { Name = "id", IsIdentity = true }; * table1.Columns.Add(id); * table1.PrimaryKey = new AddPrimaryKeyOperation(); * table1.PrimaryKey.Columns.Add("id"); * operations.Add(table1); * var sql = gen.Generate( operations , "2008");*/ /*var db = new Model1(); * var list = db.getdata(); * var json = Newtonsoft.Json.JsonConvert.SerializeObject(list); * Type listtype = typeof(List<>).MakeGenericType(db.type); * var obj = JsonConvert.DeserializeObject(json, listtype);*/ //list.Where(new ) TableTemplate template = new TableTemplate() { Name = "TEMPLATE_100" }; template.Fields.Add(new TableTemplateField() { Name = "ND", Type = TableTemplateFieldType.String, Length = 20 }); template.Fields.Add(new TableTemplateField() { Name = "FLH", Type = TableTemplateFieldType.String, Length = 20 }); template.Fields.Add(new TableTemplateField() { Name = "AJH", Type = TableTemplateFieldType.Int }); template.Fields.Add(new TableTemplateField() { Name = "DH", Type = TableTemplateFieldType.String, Length = 50 }); template.Fields.Add(new TableTemplateField() { Name = "AJTM", Type = TableTemplateFieldType.String, Length = 200 }); template.Fields.Add(new TableTemplateField() { Name = "BGQX", Type = TableTemplateFieldType.String, Length = 20 }); template.Fields.Add(new TableTemplateField() { Name = "DW", Type = TableTemplateFieldType.String, Length = 100 }); var sql = template.SQLGenerateCreateTable("T_100"); var type = template.CreateType("T_100", "T_100"); ///using (var db = new Model1(new List<Type>() { type })) { /*//var tran = db.Database.BeginTransaction(); * db.Database.ExecuteSqlCommand(sql); * var list = db.getdata(type,"sys_id", 1); * tran.Rollback();*/ //db.Database.Connection. //var ss = System.Data.Entity.Core.Common.DbProviderServices. // var list = db.getdata(type, "sys_id", 1); } var sqla = template.SQLGenerateAlterTable("dddddddd"); }