DeleteNav 一对多导航删除提示空引用 返回
Object reference not set to an instance of an object.
在 SqlSugar.DeleteNavProvider`2.<>c__DisplayClass3_0`1.<DeleteOneToMany>b__2(Object it)
在 System.Linq.Enumerable.SelectListIterator`2.ToList()
在 System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
在 SqlSugar.DeleteNavProvider`2.DeleteOneToMany[TChild](String name, EntityColumnInfo nav)
在 SqlSugar.DeleteNavProvider`2.ThenInclude[TChild](Expression`1 expression)
在 SqlSugar.DeleteNavTaskInit`2.<>c__DisplayClass15_0`1.<Include>b__0()
在 SqlSugar.DeleteNavTask`2.ExecuteCommand()
在 sqltest.Program.Main(String[] args) 在 D:\project\sqltest\Program.cs 中: 第 32 行。
具体代码:
using System;
using Models;
using SqlSugar;
namespace sqltest
{
// 定义实体类,对应ocms_codedata表
class Program
{
static void Main(string[] args)
{
Console.WriteLine("开始执行数据库操作...");
// 创建SqlSugar实例
SqlSugarClient Db = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString =
"server=10.1.36.245;database=ocms_ocms_gljzl_492l;uid=root;pwd=123456;CharSet=utf8mb4;SslMode=none;AllowLoadLocalInfile=true",
DbType = DbType.MySql,
IsAutoCloseConnection = true,
InitKeyType = InitKeyType.Attribute
},db => {
db.Aop.OnLogExecuting = (sql, pars) =>
{
//获取原生SQL推荐 5.1.4.63 性能OK
Console.WriteLine(UtilMethods.GetNativeSql(sql, pars));
};
});
Db.DeleteNav<ocms_codedata>(it => it.PrintDate <=DateTime.Now.AddDays(-7))
.Include(z1 => z1.Extensions)
.ExecuteCommand();
}
}
}
实体类:
using System;
using System.Linq;
using System.Text;
namespace Models
{
///<summary>
///
///</summary>
public partial class ocms_codedata_extension
{
public ocms_codedata_extension(){
}
/// <summary>
/// Desc:
/// Default:
/// Nullable:False
/// </summary>
[SqlSugar.SugarColumn(IsPrimaryKey =true)]
public string id {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:False
/// </summary>
public string Code {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:False
/// </summary>
public string extensionKey {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:False
/// </summary>
public string extensionValue {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:False
/// </summary>
public DateTime AddTime {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:True
/// </summary>
public string OrderCode {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:True
/// </summary>
public string workTaskId {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:True
/// </summary>
public int? Level {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:True
/// </summary>
public int? ExportStatus {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:True
/// </summary>
public string InsiderOrderCode {get;set;}
}
}
子类:
using System;
using System.Linq;
using System.Text;
namespace Models
{
///<summary>
///
///</summary>
public partial class ocms_codedata_extension
{
public ocms_codedata_extension(){
}
/// <summary>
/// Desc:
/// Default:
/// Nullable:False
/// </summary>
[SqlSugar.SugarColumn(IsPrimaryKey =true)]
public string id {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:False
/// </summary>
public string Code {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:False
/// </summary>
public string extensionKey {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:False
/// </summary>
public string extensionValue {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:False
/// </summary>
public DateTime AddTime {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:True
/// </summary>
public string OrderCode {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:True
/// </summary>
public string workTaskId {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:True
/// </summary>
public int? Level {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:True
/// </summary>
public int? ExportStatus {get;set;}
/// <summary>
/// Desc:
/// Default:
/// Nullable:True
/// </summary>
public string InsiderOrderCode {get;set;}
}
}
热忱回答(1)
-
fate sta VIP0
2周前https://www.donet5.com/Home/Doc?typeId=2366
导航问题,需要按模版提供可以重现的DEMO
0 回复