Comments (8)
declare @NAMEs table ([name] nvarchar(30))
insert into @NAMEs values
(@T_For__tags_0)
,
(@T_For__tags_1).......
这段Sql能执行成功吗?每句Sql后面加上分号试试。
from smartsql.
假设完整的业务链是这样的:插入文章-> 插入Tags 跟 Categories -> 完成。
然后根据你的提示我做了以下尝试:
- 插入文章 -> 插入Tags -> 成功
- 插入文章 -> 插入Categories -> 成功
(到这里说明SQL应该是没有问题的。) - 插入文章 -> 插入 Tags 和 Categories -> 失败,提示:
The connection does not support MultipleActiveResultSets
- 加入分号再执行第 3 步,结果同 3
- 把第 4 步日志中的带参 SQL 拼接好到查询窗口执行 -> 成功
还有没有可以尝试的方法呢?
from smartsql.
@Seanwong933 连接字符串增加 MultipleActiveResultSets=true
from smartsql.
异步方法前面统一带上await
from smartsql.
谢谢帮助,才知道MultipleActiveResultSets
是连接字符串的东西。
from smartsql.
@Seanwong933 方便的话可以提供一下 #13
from smartsql.
@Ahoo-Wang 我是个人开源项目使用的,可能不符合你们的条件,如果可以的话我在开发完毕后再评论上去。
from smartsql.
@Ahoo-Wang 我是个人开源项目使用的,可能不符合你们的条件,如果可以的话我在开发完毕后再评论上去。
OK,感谢。
from smartsql.
Related Issues (20)
- 实现mybatis 的 Example HOT 2
- 升级到net5 HOT 7
- Where或者Dynamic没有任何命中时,会产生不合法的语句 HOT 2
- 找不到配置项的异常提示有点迷 HOT 5
- where条件里In查询是怎么写的 HOT 1
- select * 报错,改为select id,name.... 全部列名就没事 HOT 2
- 升级版本后ISmartSqlMapper,SmartSql.Abstractions找不到
- 建议将DbProvider的配置放到配置文件中 HOT 12
- for
- 哪里有smartsql的学习网站,感觉官网写的太笼统了,而且用的人也不是很多 HOT 4
- Oracle 中的union all 语句 smartsql不支持,请帮忙看下。 HOT 4
- IList<string> List<T> 类似的泛型在反序列化时报错
- SmartSql目前是否还在维护?
- The unit test project (SmartSql.Test.Unit) uses MySql as the database for easy integration testing. HOT 1
- Dependency Dashboard
- 最近一次修改SqlText.cs中的正则表达式,会导致有些情况下匹配错误
- 使用In时,当集合元素过多时,执行效率会大幅降低 HOT 4
- Settings.ParameterPrefix is not affected in method using StatementAttribute HOT 2
- Oracle存储过程,返回参数没有游标
- Parameter新增DbType属性,直接指定数据库字段类型,无需配置TypeHandler
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from smartsql.