使用sqlsugar
生成对应的实体时的问题。数据库中有几张表名中有空格,如Order Detail
,Customer Info
之类的,生成对应实体类时,名字中也有空格,这在C#类命名中是违法的,所以这里做记录,去掉对应表名中的空格
/// <summary>
/// 数据初始化
/// </summary>
/// <returns></returns>
public ActionResult DnInit()
{
string path = @"c:\DbEntities"; //保存路径
string nameSpace = "Entities"; //命名空间
try
{
SqlSugarClient db = new DbContext().Db; //SqlSugarClient对象
List<DbTableInfo> dbTables = new List<DbTableInfo>();
dbTables.AddRange(db.DbMaintenance.GetTableInfoList()); //表
dbTables.AddRange(db.DbMaintenance.GetViewInfoList()); //视图
//遍历
foreach (var item in dbTables)
{
//添加表映射
db.MappingTables.Add(item.Name.Replace(" ", string.Empty), item.Name);
}
db.DbFirst.IsCreateAttribute().IsCreateDefaultValue().CreateClassFile(path, nameSpace);
return View("success" as object);
}
catch (Exception)
{
throw;
}
}