ADO.NET 实体 - 需要帮助

发布于 2024-09-16 05:59:59 字数 777 浏览 3 评论 0原文

我的数据库中有 3 个表，我从数据库创建了一个实体模型，它看起来像这样： alt text

我想做的是将所有 3 个表绑定到 datagridview，并且我使用这样的查询

var result = from t in db.Transactions
                    from c in db.Categories
                    from a in db.Accounts
                    where t.FkCategoryID == c.CategoryID && t.FkAccountID == a.AccountID
                    select new { t.Description, t.BankReference, t.TransactionDate, c.CategoryName, a.AccountName, a.AccountNr };

效果很好。但我需要能够使用绑定导航器工具栏来更新事务表

alt text

我无法做到这一点使用 linq 查询并将其绑定到 gridview。

有没有办法通过使用实体框架来实现这一点？我的意思是，当我仅将一个表绑定到绑定源时，我可以使用该工具栏删除更新并添加行，但我必须显示所有表，并且只能编辑事务表

提前致谢

原文

i have 3 tables in my database and i created a entity model from database and it looks like this:
alt text

what im trying to do is to bind all 3 tables to datagridview and im using a query like this

var result = from t in db.Transactions
                    from c in db.Categories
                    from a in db.Accounts
                    where t.FkCategoryID == c.CategoryID && t.FkAccountID == a.AccountID
                    select new { t.Description, t.BankReference, t.TransactionDate, c.CategoryName, a.AccountName, a.AccountNr };

this works well.
But i need to be able to update the Transaction table by using the binding navigator toolbar

alt text

im not able to do that by using linq query and binding it to gridview.

Is there any way to accomplish that by using entity framework? I mean when i bind only one table to binding source im able to use that toolbar to delete update and add row but i have to show all tables and only be able to edit Transaction table

Thanks in advance

分享到QQ

分享到微博