public Result InsertHouseInfos()
{
Result ret = new Result();
using (var smartConn = new SmartWorldEntities())
{
for (int i = 1; i <= 3; i++)
{
D_House r = new D_House()
{
Id = Guid.NewGuid(),
Address = "成都",
Floor = i,
HouseCode = DateTime.Now.Date.ToString(),
HouseTitle = "测试" + i,
Price = 100,
Remark = "说明",
Property = (int)PropertyType.私证,
CreateDate = DateTime.Now,
HouseType = (int)HouseType.出租,
YearPrice = 1000,
IsDelete = false
};
//List<int> GetListEnum = PropertyType.私证.GetListEnum<int>(typeof(int));
//List<string> GetListEnum2 = PropertyType.私证.GetListEnum<string>(typeof(string));
smartConn.D_House.Add(r);
}
ret.Success = smartConn.SaveChanges() > 0;
}
return(ret);
}
public string GetTimeTest()
{
List <D_House> list1 = new List <D_House>();
List <D_House> list2 = new List <D_House>();
List <D_House> list3 = new List <D_House>();
using (var smartConn = new SmartWorldEntities())
{
Stopwatch watch1 = new Stopwatch();
watch1.Start();
for (int i = 1; i <= 2000; i++)
{
D_House r = new D_House()
{
Id = Guid.NewGuid(),
Address = "成都",
Floor = i,
HouseCode = DateTime.Now.Date.ToString(),
HouseTitle = "测试" + i,
Price = 100,
Remark = "说明",
Property = (int)PropertyType.私证,
CreateDate = DateTime.Now,
HouseType = (int)HouseType.出租,
YearPrice = 1000,
IsDelete = false
};
list1.Add(r);
}
smartConn.D_House.AddRange(list1);
watch1.Stop();
Stopwatch watch2 = new Stopwatch();
watch2.Start();
for (int i = 1; i <= 2000; i++)
{
D_House r = new D_House()
{
Id = Guid.NewGuid(),
Address = "成都",
Floor = i,
HouseCode = DateTime.Now.Date.ToString(),
HouseTitle = "测试" + i,
Price = 100,
Remark = "说明",
Property = (int)PropertyType.私证,
CreateDate = DateTime.Now,
HouseType = (int)HouseType.出租,
YearPrice = 1000,
IsDelete = false
};
list2.Add(r);
}
smartConn.BulkInsert(list2);
smartConn.SaveChanges();
watch2.Stop();
Stopwatch watch3 = new Stopwatch();
//watch3.Start();
//for (int i = 1; i <= 2000; i++)
//{
// D_House r = new D_House()
// {
// Id = Guid.NewGuid(),
// Address = "成都",
// Floor = i,
// HouseCode = DateTime.Now.Date.ToString(),
// HouseTitle = "测试" + i,
// Price = 100,
// Remark = "说明",
// Property = (int)PropertyType.私证,
// CreateDate = DateTime.Now,
// HouseType = (int)HouseType.出租,
// YearPrice = 1000,
// IsDelete = false
// };
// smartConn.D_House.Add(r);
//}
//smartConn.SaveChanges();
watch3.Stop();
string ret = string.Format(@" AddRange:{0}；
BulkInsert:{1}；
先添加后保存:{2}；", watch1.Elapsed, watch2.Elapsed, watch3.Elapsed);
return(ret);
}
}
