江苏企业网站建设公司上海品牌建站

江苏企业网站建设公司,上海品牌建站,wordpress 弹出框,光辉网站建设之前发表一个ABP框架EF执行原生sql#xff0c;后来自己想了想安装Dapper#xff0c;用Dapper执行原生sql也可以#xff0c;并且效率会比EF优一点。 一、首先安装Dapper 有多种方案安装#xff0c;nuget包安装#xff0c;或者执行命令 dotnet add package Dapper 二、项…之前发表一个ABP框架EF执行原生sql后来自己想了想安装Dapper用Dapper执行原生sql也可以并且效率会比EF优一点。一、首先安装Dapper有多种方案安装nuget包安装或者执行命令dotnet add package Dapper二、项目中使用注意在当前文件引用Dapperusing Dapper;注入你要操作表的仓储private readonly IRepositoryWorkOrder, Guid _repository; public WorkOrderExtensionService( IRepositoryWorkOrder, Guid repository){ _repository repository; }写好自己要的sql业务然后通过Dapper执行var parameters new { TenantId _currentTenant.Id, SkipCount input.SkipCount, PageSize input.MaxResultCount, OrderId orderId, OrderNo input.OrderNo, }; var sql select w.SeriesNo,w.Seq, CASE WHEN r.SnCode is null THEN 0 ELSE 1 END State from JG_WorkOrderTasks w left join ( select SnCode from JG_WorkOrderDistributionRecords where WorkOrderNumber OrderNo and DispatchStatus 1 group by SnCode ) r on w.SeriesNo r.SnCode where w.OrderId OrderId and IsDeleted 0 and TenantId TenantId order by State, Seq limit PageSize offset SkipCount; var countSql select count(0) from JG_WorkOrderTasks where OrderId OrderId and IsDeleted 0 and TenantId TenantId; var dbContext await _repository.GetDbContextAsync(); var connection dbContext.Database.GetDbConnection(); if (connection.State ! ConnectionState.Open) await connection.OpenAsync(); var list await connection.QueryAsync(sql, parameters); var snCount await connection.ExecuteScalarAsyncint(countSql, parameters); ListHitList resData list.Select(c new HitList { SnCode c.SeriesNo, Seq c.Seq, HitState c.State 0 ? 未打标 : 已打标 }).ToList();三、解析一下上面代码数据库上下文和连接var dbContext await _repository.GetDbContextAsync(); var connection dbContext.Database.GetDbConnection(); if (connection.State ! ConnectionState.Open) await connection.OpenAsync();通过_repository获取数据库上下文并获取数据库连接。检查连接状态如果未打开则异步打开连接。执行查询var list await connection.QueryAsync(sql, parameters); var snCount await connection.ExecuteScalarAsyncint(countSql, parameters);使用 Dapper 的QueryAsync方法执行主查询返回一个结果列表。使用ExecuteScalarAsyncint执行计数查询返回总记录数。使用 Dapper 作为 ORM使得 SQL 查询更为简洁高效同时通过参数化查询提高了安全性防止 SQL 注入。整体结构清晰符合常见的 .NET 开发模式。