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");
}