English 中文(简体)
如何用 v冷却储存执行储存程序?
原标题:how do i execute a stored procedure with vici coolstorage?

I m Building an app around Vicigilstorage (asp.net edition). 我的班子已经制作并绘制到我的数据库表上,能够把所有记录的清单删除。

我撰写了一份储存程序,在这种程序中,电离层跳跃穿冷静状态的数据库,然而,电离层结果地图中的田地直接到我的一个班级。 程序参数为1。

因此,有两个问题:

如何执行所储存的程序? i 这样做

CSParameterCollection collection = new CSParameterCollection();
collection.Add("@id", id);
var result = Vici.CoolStorage.CSDatabase.RunQuery("procedurename", collection);

并且获得“接近程序名称”这一例外情况(因为试图作为案文而不是程序加以执行)

并且,由于代表我的表格的类别被定义为抽象的,因此,如何规定结果应当编制一份清单,列出可使用的物体,而不是通用的或动态的物体或任何物体? 审判

Vici.CoolStorage.CSDatabase.RunQuery<MyTable>(...)

各位编辑,我认为这是抽象的。

最佳回答

冷藏处有一个捷径,以管理储存程序。 简单地预先确定所储存的程序名称:“......”

 CSDatabase.RunQuery("!procedurename", collection);
问题回答

暂无回答




相关问题
LINQ to SQL optional Column

I need a functionality to have optional columns in a LINQ to SQL definition. So that LINQ to SQL normally ignores this column within selects and updates etc. But if a select contains a value for this ...

Optional where clause / parameter in a SQL 2008 stored proc?

I m writing some code that updates a table. Depending on what the user wants to do, it either updates a large set of records, or a smaller one. The delineating factor is a group ID. The user can ...

How to control access to a Stored Procedure in SQL Server?

I want to be able to have a Stored Procedure that can only be used from a particular page, without having to create a permissions / role for a user, when it is just a single stored procedure I want ...

Selecting records during recursive stored procedure

I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...

热门标签