创建存储过程报错了 返回
SqlSugar
沟通中
2
284
悬赏:0 飞吻
using SqlSugar;
using SqlSugar.IOC;
namespace sugarTest
{
internal class Program
{
static string conn1 = "Data Source=.;Initial Catalog=test1;Persist Security Info=True;User ID=sa;Password=123456;Encrypt=True;TrustServerCertificate=True;";
static IocDbType _iocDbType = IocDbType.SqlServer;
static void Main(string[] args)
{
List<IocConfig> iocList1 = new List<IocConfig>
{
new IocConfig()
{
ConfigId="TEST1",
ConnectionString = conn1,
DbType = _iocDbType,
IsAutoCloseConnection = true,
}
};
SugarIocServices.AddSqlSugar(iocList1);
var db = DbScoped.SugarScope;
string proc = @"
IF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME = 'Proc_Test' AND TYPE = 'P')
BEGIN
DROP PROC Proc_Test
END
Go
CREATE PROC Proc_Test
@query VARCHAR(50)
AS
BEGIN
SELECT @query as test
END
GO
";
var connect1 = db.GetConnection("TEST1");
//建库:如果不存在创建数据库存在不会重复创建
connect1.Ado.ExecuteCommand(proc);
Console.WriteLine("Hello, World!");
}
}
}connect1.Ado.ExecuteCommand(proc);

但是这个在Studio里面是可以执行的。

热忱回答(2)
-
fate sta VIP0
2025/11/14connect1.Ado.ExecuteCommandWithGo(proc);0 回复 -
ABC VIP0
2025/11/17@fate sta:建议ExecuteCommand去兼容ExecuteCommandWithGo,一般人真找不到解决方案,真不好解决这个问题。
0 回复