EntityFramework Any 生成的sql语句超长。

最新推荐文章于 2021-07-28 14:36:22 发布
最新推荐文章于 2021-07-28 14:36:22 发布
阅读量174 收藏
点赞数
今天早上在做一个新功能的时候发现了有一个bug.

跟踪的时候发现

 

Service Error: SQL 语句的某些部分嵌套过深。请重写查询或将其分解为若干较小的查询。. <!-- at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)-->

 

看一下我们的linq语句

   var query2 = ctx.Boxes.Where(b => PartyIds.Any(d => d == b.PartyID)); ParyIds是一个Int[]数组有72数字在里面

结果它生成的sql语句就超恐怖了。

 

SELECT
[Extent1].[Discriminator] AS [Discriminator],
[Extent1].[ID] AS [ID],
[Extent1].[PartyID] AS [PartyID],

FROM [dbo].[Boxes] AS [Extent1]
WHERE ([Extent1].[Discriminator] IN ('Inbox','Outbox','Box')) AND ( EXISTS (SELECT
1 AS [C1]
FROM (SELECT
[UnionAll70].[C1] AS [C1]
FROM (SELECT
[UnionAll69].[C1] AS [C1]
FROM (SELECT
[UnionAll68].[C1] AS [C1]
FROM (SELECT
[UnionAll67].[C1] AS [C1]
FROM (SELECT
[UnionAll66].[C1] AS [C1]
FROM (SELECT
[UnionAll65].[C1] AS [C1]
FROM (SELECT
[UnionAll64].[C1] AS [C1]
FROM (SELECT
[UnionAll63].[C1] AS [C1]
FROM (SELECT
[UnionAll62].[C1] AS [C1]
FROM (SELECT
[UnionAll61].[C1] AS [C1]
FROM (SELECT
[UnionAll60].[C1] AS [C1]
FROM (SELECT
[UnionAll59].[C1] AS [C1]
FROM (SELECT
[UnionAll58].[C1] AS [C1]
FROM (SELECT
[UnionAll57].[C1] AS [C1]
FROM (SELECT
[UnionAll56].[C1] AS [C1]
FROM (SELECT
[UnionAll55].[C1] AS [C1]
FROM (SELECT
[UnionAll54].[C1] AS [C1]
FROM (SELECT
[UnionAll53].[C1] AS [C1]
FROM (SELECT
[UnionAll52].[C1] AS [C1]
FROM (SELECT
[UnionAll51].[C1] AS [C1]
FROM (SELECT
[UnionAll50].[C1] AS [C1]
FROM (SELECT
[UnionAll49].[C1] AS [C1]
FROM (SELECT
[UnionAll48].[C1] AS [C1]
FROM (SELECT
[UnionAll47].[C1] AS [C1]
FROM (SELECT
[UnionAll46].[C1] AS [C1]
FROM (SELECT
[UnionAll45].[C1] AS [C1]
FROM (SELECT
[UnionAll44].[C1] AS [C1]
FROM (SELECT
[UnionAll43].[C1] AS [C1]
FROM (SELECT
[UnionAll42].[C1] AS [C1]
FROM (SELECT
[UnionAll41].[C1] AS [C1]
FROM (SELECT
[UnionAll40].[C1] AS [C1]
FROM (SELECT
[UnionAll39].[C1] AS [C1]
FROM (SELECT
[UnionAll38].[C1] AS [C1]
FROM (SELECT
[UnionAll37].[C1] AS [C1]
FROM (SELECT
[UnionAll36].[C1] AS [C1]
FROM (SELECT
[UnionAll35].[C1] AS [C1]
FROM (SELECT
[UnionAll34].[C1] AS [C1]
FROM (SELECT
[UnionAll33].[C1] AS [C1]
FROM (SELECT
[UnionAll32].[C1] AS [C1]
FROM (SELECT
[UnionAll31].[C1] AS [C1]
FROM (SELECT
[UnionAll30].[C1] AS [C1]
FROM (SELECT
[UnionAll29].[C1] AS [C1]
FROM (SELECT
[UnionAll28].[C1] AS [C1]
FROM (SELECT
[UnionAll27].[C1] AS [C1]
FROM (SELECT
[UnionAll26].[C1] AS [C1]
FROM (SELECT
[UnionAll25].[C1] AS [C1]
FROM (SELECT
[UnionAll24].[C1] AS [C1]
FROM (SELECT
[UnionAll23].[C1] AS [C1]
FROM (SELECT
[UnionAll22].[C1] AS [C1]
FROM (SELECT
[UnionAll21].[C1] AS [C1]
FROM (SELECT
[UnionAll20].[C1] AS [C1]
FROM (SELECT
[UnionAll19].[C1] AS [C1]
FROM (SELECT
[UnionAll18].[C1] AS [C1]
FROM (SELECT
[UnionAll17].[C1] AS [C1]
FROM (SELECT
[UnionAll16].[C1] AS [C1]
FROM (SELECT
[UnionAll15].[C1] AS [C1]
FROM (SELECT
[UnionAll14].[C1] AS [C1]
FROM (SELECT
[UnionAll13].[C1] AS [C1]
FROM (SELECT
[UnionAll12].[C1] AS [C1]
FROM (SELECT
[UnionAll11].[C1] AS [C1]
FROM (SELECT
[UnionAll10].[C1] AS [C1]
FROM (SELECT
[UnionAll9].[C1] AS [C1]
FROM (SELECT
[UnionAll8].[C1] AS [C1]
FROM (SELECT
[UnionAll7].[C1] AS [C1]
FROM (SELECT
[UnionAll6].[C1] AS [C1]
FROM (SELECT
[UnionAll5].[C1] AS [C1]
FROM (SELECT
[UnionAll4].[C1] AS [C1]
FROM (SELECT
[UnionAll3].[C1] AS [C1]
FROM (SELECT
[UnionAll2].[C1] AS [C1]
FROM (SELECT
[UnionAll1].[C1] AS [C1]
FROM (SELECT
89 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable1]
UNION ALL
SELECT
88 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable2]) AS [UnionAll1]
UNION ALL
SELECT
87 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable3]) AS [UnionAll2]
UNION ALL
SELECT
86 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable4]) AS [UnionAll3]
UNION ALL
SELECT
85 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable5]) AS [UnionAll4]
UNION ALL
SELECT
84 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable6]) AS [UnionAll5]
UNION ALL
SELECT
83 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable7]) AS [UnionAll6]
UNION ALL
SELECT
82 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable8]) AS [UnionAll7]
UNION ALL
SELECT
81 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable9]) AS [UnionAll8]
UNION ALL
SELECT
80 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable10]) AS [UnionAll9]
UNION ALL
SELECT
79 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable11]) AS [UnionAll10]
UNION ALL
SELECT
78 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable12]) AS [UnionAll11]
UNION ALL
SELECT
77 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable13]) AS [UnionAll12]
UNION ALL
SELECT
76 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable14]) AS [UnionAll13]
UNION ALL
SELECT
75 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable15]) AS [UnionAll14]
UNION ALL
SELECT
72 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable16]) AS [UnionAll15]
UNION ALL
SELECT
71 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable17]) AS [UnionAll16]
UNION ALL
SELECT
70 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable18]) AS [UnionAll17]
UNION ALL
SELECT
69 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable19]) AS [UnionAll18]
UNION ALL
SELECT
68 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable20]) AS [UnionAll19]
UNION ALL
SELECT
67 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable21]) AS [UnionAll20]
UNION ALL
SELECT
66 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable22]) AS [UnionAll21]
UNION ALL
SELECT
65 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable23]) AS [UnionAll22]
UNION ALL
SELECT
64 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable24]) AS [UnionAll23]
UNION ALL
SELECT
63 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable25]) AS [UnionAll24]
UNION ALL
SELECT
62 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable26]) AS [UnionAll25]
UNION ALL
SELECT
61 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable27]) AS [UnionAll26]
UNION ALL
SELECT
60 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable28]) AS [UnionAll27]
UNION ALL
SELECT
59 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable29]) AS [UnionAll28]
UNION ALL
SELECT
55 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable30]) AS [UnionAll29]
UNION ALL
SELECT
54 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable31]) AS [UnionAll30]
UNION ALL
SELECT
53 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable32]) AS [UnionAll31]
UNION ALL
SELECT
52 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable33]) AS [UnionAll32]
UNION ALL
SELECT
51 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable34]) AS [UnionAll33]
UNION ALL
SELECT
50 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable35]) AS [UnionAll34]
UNION ALL
SELECT
49 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable36]) AS [UnionAll35]
UNION ALL
SELECT
48 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable37]) AS [UnionAll36]
UNION ALL
SELECT
47 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable38]) AS [UnionAll37]
UNION ALL
SELECT
46 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable39]) AS [UnionAll38]
UNION ALL
SELECT
45 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable40]) AS [UnionAll39]
UNION ALL
SELECT
44 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable41]) AS [UnionAll40]
UNION ALL
SELECT
43 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable42]) AS [UnionAll41]
UNION ALL
SELECT
42 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable43]) AS [UnionAll42]
UNION ALL
SELECT
41 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable44]) AS [UnionAll43]
UNION ALL
SELECT
40 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable45]) AS [UnionAll44]
UNION ALL
SELECT
39 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable46]) AS [UnionAll45]
UNION ALL
SELECT
38 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable47]) AS [UnionAll46]
UNION ALL
SELECT
37 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable48]) AS [UnionAll47]
UNION ALL
SELECT
36 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable49]) AS [UnionAll48]
UNION ALL
SELECT
35 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable50]) AS [UnionAll49]
UNION ALL
SELECT
34 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable51]) AS [UnionAll50]
UNION ALL
SELECT
33 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable52]) AS [UnionAll51]
UNION ALL
SELECT
32 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable53]) AS [UnionAll52]
UNION ALL
SELECT
31 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable54]) AS [UnionAll53]
UNION ALL
SELECT
30 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable55]) AS [UnionAll54]
UNION ALL
SELECT
29 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable56]) AS [UnionAll55]
UNION ALL
SELECT
28 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable57]) AS [UnionAll56]
UNION ALL
SELECT
27 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable58]) AS [UnionAll57]
UNION ALL
SELECT
26 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable59]) AS [UnionAll58]
UNION ALL
SELECT
25 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable60]) AS [UnionAll59]
UNION ALL
SELECT
24 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable61]) AS [UnionAll60]
UNION ALL
SELECT
23 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable62]) AS [UnionAll61]
UNION ALL
SELECT
22 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable63]) AS [UnionAll62]
UNION ALL
SELECT
21 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable64]) AS [UnionAll63]
UNION ALL
SELECT
20 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable65]) AS [UnionAll64]
UNION ALL
SELECT
19 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable66]) AS [UnionAll65]
UNION ALL
SELECT
18 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable67]) AS [UnionAll66]
UNION ALL
SELECT
17 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable68]) AS [UnionAll67]
UNION ALL
SELECT
16 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable69]) AS [UnionAll68]
UNION ALL
SELECT
3 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable70]) AS [UnionAll69]
UNION ALL
SELECT
2 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable71]) AS [UnionAll70]
UNION ALL
SELECT
1 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable72]) AS [UnionAll71]
WHERE [UnionAll71].[C1] = [Extent1].[PartyID]
))

 


 

 换成另一种写法就ok了

var query = from it in ctx.Boxes where PartyIds.Contains(it.PartyID) select it;

生成的sql语句就跟我们正常写的差不多了
SELECT
[Extent1].[ID] AS [ID],
[Extent1].[Discriminator] AS [Discriminator],
[Extent1].[PartyID] AS [PartyID],

FROM [dbo].[Boxes] AS [Extent1]
WHERE ([Extent1].[Discriminator] IN ('Inbox','Outbox','Box')) AND ([Extent1].[PartyID] IN (89,88,87,86,85,84,83,82,81,80,79,78,77,76,75,72,71,70,69,68,67,66,65,64,63,62,61,60,59,55,54,53,52,51,50,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,3,2,1))

 

 

 

 

weixin_34195142
关注
C# Entity Framework 入门指南：与数据库愉快玩耍
java专栏
08-21 1159
🎉 恭喜你完成了这篇深入浅出的 Entity Framework 入门指南！现在你已经掌握了使用 EF 和 EF Core 进行基本的数据库操作。记得不断练习，让自己的技能更加熟练！🚀。
.NET EF~Entity Framework详解（lambda表达式、linq到EF）
qq_43434300的博客
05-11 1951
1.Entity Framework 1.1相关知识复习 var类型推断：var p =new Person(); 匿名类型。var a =new {p.Name,Age=5,Gender=p.Gender,Name1=a.Name};//{p.Name}=={Name=p.Name} 给新创建对象的属性赋值的简化方法：Person p = new Person{Name=“tom”,Age=5...
EntityFramework 简单入个门
weixin_30848775的博客
01-19 132
　　任何一个和数据相关的系统里，数据持久化都是一个不容忽视的问题。 　　一直以来，Java 平台出了很多 NB 的 ORM 框架，Hibernate、MyBatis等等。.NET 平台上，ORM 框架这一块一直没有一个能吊到让几乎所有开发人员改掉以拼写 SQL 语句访问数据库的习惯。 　　实际上，在 .NET 平台上，也层出不穷的出现了很多类似的玩意儿，比如Nhibernate、Ibatis，...
AppBox升级进行时 - Any与All的用法（Entity Framework）
weixin_34406061的博客
09-18 132
AppBox 是基于 FineUI 的通用权限管理框架，包括用户管理、职称管理、部门管理、角色管理、角色权限管理等模块。 属于某个角色的用户列表（Any的用法） 使用Subsonic，我们有两种方法获取属于某个角色的用户列表，分别是表关联和子查询。 Subsonic的表关联实现： // 查询 X_User 表 SqlQuery q = new Select().From&lt...
.NET Core MySQL EntityFrameworkCore EF生成SQL语句 打印SQL语句
KingCruel的专栏
03-18 2657
Creating a Database with Code First in EF Core MySql.EntityFrameworkCore MySql.Data.EntityFrameworkCore 1、实体类 [Table("Book")] public class BookDo : DoBase { [Key] [Column("id")] public int Id { get; set; } [Column("title")] public string Title
SQL语句部分使用
智树的博客
10-16 185
基于普通增删查改大家已经烂熟于心，说点新鲜的 扩充以存在表的字段也就是新增已存在表字段 alert table 表A add column 字段 varchar(2) 给已存在表的属性赋值 update 表A set 属性值= 期待值 很简单了吧哈哈哈 ...
Code First Entity Framework动态组合Lambda表达式作为数据筛选条件，代替拼接SQL语句
热门推荐
LeeWhoee University
05-24 1万+
传统的操作数据库方式，筛选数据需要用StringBuilder拼接一大堆的WHERE子句。在Code First Entity Framework中，或许有人不断地.Where(m=>m.....)。问题来了，ID>1200和ID<1000的结果集在使用两次判断的情况下，怎么在EF中实现呢？if(条件1){list=list.Where(s=>s.ID>1200);}if(条件2){list=list.Where(s=>s.ID<1000);},结果是空集！！！看文中解决方案
Entity Framework 6 Recipes 中文翻译系列-By博客园-china_fucan
08-17
### Entity Framework 6 Recipes 中文翻译系列知识点梳理 #### 一、第一章 开始使用实体框架 **1-1 实体框架简述** - **概念**：实体框架（Entity Framework，简称EF）是一种由Microsoft开发的对象-关系映射（ORM...
.NET EF（Entity Framework）详解
weixin_44870681的博客
10-31 5613
一丶Entity Framework （一）EF简介 （1）ORM：Object Relation Mapping ，通俗说：用操作对象的方式来操作数据库。 （2）插入数据库不再是执行Insert，而是类似于Person p = new Person();p.Age=3;p.Name=“英莱特”;db.Save§;这样的做法。 （3）ORM工具有很多Dapper、PetaPoco、NHiberna...
根据EntityFramework写的重写sql语句的类
weixin_33708432的博客
11-27 149
代码如下 View Code 1 class ReSql { 2 #region 防sql注入重写sql语句//出自http://www.cnblogs.com/ahjesus 尊重作者辛苦劳动成果,转载请注明出处,谢谢! 3 public string RewriteSql(string sql) { 4 sql =...
工作笔记-SQL语句部分
王小浩的博客
08-20 361
sql语句部分
关于SQL Server的若干注意事项
dy_2000_abc的专栏
11-11 1319
关于SQL Server的若干注意事项        如果你正在负责一个基于SQL Server的项目，或者你刚刚接触SQL Server，你都有可能要面临一些数据库性能的问题，这篇文章会为你提供一些有用的指导（其中大多数也可以用于其它的DBMS）。        在这里，我不打算介绍使用SQL Server的窍门，也不能提供一个包治百病的方案，我所做的是总结一些经验----关于如何形成一
EF Core 基于包管理器控制台生成模型（1）
qq_43045747的博客
07-28 308
安装工具 在 Package Manager console 中运行以下命令，安装包管理器控制台工具 Install-Package Microsoft.EntityFrameworkCore.Tools 在 Package Manager Console 中运行以下命令，更新这些工具。 Update-Package Microsoft.EntityFrameworkCore.Tools 验证安装 通过运行以下命令验证是否已安装这些工具： Get-Help about_EntityFra
Entity Framework——使用SQL语句查询
Wlk1229
04-15 3867
使用SQL语句查询使用SQL语句查询比使用Linq更加灵活，查询效率也可以更高。EntityFramework支持直接使用SQL语句查询，使用DbContext.Database. SqlQuery&lt; TElement &gt;函数查询。该函数的文档介绍如下：// Creates a raw SQL query that will return elements of the giv...
Java 实体类反向生成SQL语句工具
"实体类逆向生成SQL语句的Java实现" 在软件开发中，特别是涉及到数据库操作时，实体类（Entity Class）通常被用来映射数据库表中的记录。实体类逆向生成SQL语句是一种方便的方法，它能够帮助开发者快速地根据实体类...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值