linq to sql插入语句不起作用

发布于 2024-12-05 08:48:24 字数 1167 浏览 2 评论 0原文

我有以下代码:

        pillboxDataContext db = new pillboxDataContext();

        userAccount newUser = new userAccount();
        newUser.userName = "test123";
        newUser.userPhone = "1234567890";
        newUser.userEmail = "[email protected]";
        newUser.userPwd = "testpassword";
        newUser.userCreateDate = DateTime.Now;
        newUser.userAccountType = "basic";

        db.users.Add(newUser);
        db.SubmitChanges();

userAccount 是我的具有属性的对象(与用户表匹配)。

我对 db.users.Add(newUser); 行感到困惑。 .Add 指出:System.Data.LINQ.Table 不包含“Add”的定义。

我遵循的示例似乎表明应该允许 .Add 。我对此很陌生,所以请提供任何建议都会非常有帮助。

更新:

我将其更改为db.users.InsertOnSubmit(newUser);但是,我仍然收到错误:

最佳重载方法匹配 'System.Data.Linq.Table.InsertOnSubmit(user)' 有一些无效 参数

后,

我发现我将数据分配给类(userAccount)而不是表(user)。

所以我将: userAccount newUser = new userAccount(); 更改为 user newUser = new user(); 然后一切都像我预期的那样进行。

感谢您的信息!

I have the following code:

        pillboxDataContext db = new pillboxDataContext();

        userAccount newUser = new userAccount();
        newUser.userName = "test123";
        newUser.userPhone = "1234567890";
        newUser.userEmail = "[email protected]";
        newUser.userPwd = "testpassword";
        newUser.userCreateDate = DateTime.Now;
        newUser.userAccountType = "basic";

        db.users.Add(newUser);
        db.SubmitChanges();

userAccount is my object with properties (that match up with the user table).

I'm confused on the db.users.Add(newUser); line. The .Add is stating: System.Data.LINQ.Table does not contain a definition for 'Add'.

The examples I was following seem to indicate that the .Add should be allowed. I'm new at this so please any advice would be very helpful.

UPDATE:

I changed it to db.users.InsertOnSubmit(newUser); however, I'm still getting an error:

The best overloaded method match for
'System.Data.Linq.Table.InsertOnSubmit(user)' has some invalid
arguments

Fix!

After looking at other code samples I figured out that I was assigning my data to the class (userAccount) rather than the table (user).

So I changed: userAccount newUser = new userAccount(); to user newUser = new user();
Then everything worked like I expected.

Thanks for the info!

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

柒七 2024-12-12 08:48:24

是的,Add 不起作用 - 我怀疑您想要 InsertOnSubmit< /代码>

db.users.InsertOnSubmit(newUser);
db.SubmitChanges();

Yes, Add won't work - I suspect you want InsertOnSubmit.

db.users.InsertOnSubmit(newUser);
db.SubmitChanges();
残月升风 2024-12-12 08:48:24

您的代码是:

db.users.InsertAllOnSubmit(newUser);

乔恩建议您的代码应该是:

db.users.InsertOnSubmit(newUser);

两者之间存在巨大差异。 IDE 对于这类事情非常有帮助......

Your code is:

db.users.InsertAllOnSubmit(newUser);

Jon suggested that your code should be:

db.users.InsertOnSubmit(newUser);

There is an enormous difference between the two. An IDE is very helpful for this sort of thing...

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文