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,它确实支持存储过程。