LINQ to DATASET使用存储过程进行更新

时间:2022-01-14 01:49:48

I have used LINQ to SQL with a update stored procedure to update databases in the past. I wanted to know if there is anything similar in LINQ to Dataset

我已经使用LINQ to SQL和更新存储过程来更新过去的数据库。我想知道LINQ到Dataset中是否有类似的东西

An example of the LINQ to SQL Update:

LINQ to SQL Update的一个示例:

Dim lqUpdate = lqUpdate.sprocUpdate(ColumnName, NewValue, ID)

1 个解决方案

#1


DataSets are completely disconnected entities, so you won't find any way from a DataSet or DataTable to a stored proc, but the ADO.Net equivalent of a Linq DataContext is the TableAdapter, which does have support for stored procs.

DataSet是完全断开连接的实体,因此您无法找到从DataSet或DataTable到存储过程的任何方法,但Linq DataContext的ADO.Net等效项是TableAdapter,它确实支持存储过程。

#1


DataSets are completely disconnected entities, so you won't find any way from a DataSet or DataTable to a stored proc, but the ADO.Net equivalent of a Linq DataContext is the TableAdapter, which does have support for stored procs.

DataSet是完全断开连接的实体,因此您无法找到从DataSet或DataTable到存储过程的任何方法,但Linq DataContext的ADO.Net等效项是TableAdapter,它确实支持存储过程。