如果我包含计算列，LINQ to SQL 不会更新

发布于 2024-08-21 01:13:20 字数 802 浏览 2 评论 0原文

我正在使用以下 LINQ 代码填充 DataGrid：

        Dim myClients = From p In dc.Persons _
                    Select p

我可以导航我的 DataGrid，进行更改，然后单击一个调用“

        dc.SubmitChanges()

所有这些工作正常”并更新 SQL Server 的按钮。

然后我想添加一个附加列来显示基于函数计算的年龄。我使用以下代码创建了一个 PersonAge 列并且它起作用了。

        Dim myClients = From p In dc.Persons _
                Select New With {p.PersonID, _
                     p.PersonName, _
                     p.PersonGender, _
                     .PersonAge = CalcCurrentAge(p.PersonDOB, p.PersonFirstContactDate, p.PersonFirstContactAge) _
                     }

但是，我注意到我无法再成功地将任何更新保存回 SQL。

所以我的问题是，如何利用第一个正确保存更新的 LINQ 代码的简单性，并将其与包含 PersonAge 列的第二个 LINQ 代码混合，以创建具有计算年龄列的可更新 DataGrid？

原文

I am populating a DataGrid with the following LINQ code :

        Dim myClients = From p In dc.Persons _
                    Select p

I can navigate my DataGrid, make changes and then click on a button that calls

        dc.SubmitChanges()

All of this works well and updates SQL Server.

I then wanted to add a single additional column that would display a calculated age based on a Function. I used the following code to create a PersonAge column and it worked.

        Dim myClients = From p In dc.Persons _
                Select New With {p.PersonID, _
                     p.PersonName, _
                     p.PersonGender, _
                     .PersonAge = CalcCurrentAge(p.PersonDOB, p.PersonFirstContactDate, p.PersonFirstContactAge) _
                     }

However, I noticed that I can no longer successfully save any updates back to SQL.

So my question is, how can I take the simplicity of the first LINQ code which saves updates correctly, and mix it with the second LINQ code which includes the PersonAge column to create an updatable DataGrid with a calculated age column?

分享到QQ

分享到微博