Inserting records

Shawn · October 2012

I'm having a problem getting inserts to work in LINQPad with my db. I am trying to follow numerous examples on the net which seems to indicate that the following should work:

Employee newEmployee = new Employee
{
FirstName = "Bob",
LastName = "Barker"
};
Employees.InsertOnSubmit(newEmployee);
SubmitChanges();

The problem I have is that while Employees exists in the context, Employee does not. In all the examples I have seen, this just seems to work. Any help would be appreciated, thanks.

JoeAlbahari · October 2012

Most likely the table is called Employees rather than Employee, because that's how is was defined in SQL Server.

There's an easy way to tell: In the Schema Explorer, hover over Employees and look at the tooltip.

Shawn · October 2012

Thanks for the reply, Joe. I see that it does work fine if I instantiate a new Employees object as opposed to an "Employee", thank you. The table was indeed named Employees in the database.

I suppose I'm just getting confused because things are structured a little differently than I'm used to seeing, probably because I'm using LinqPad with the database directly as opposed to working with an EF model. I've been using EF's DbContext with DbSets like Employees, Tasks, Clients while using the singluar (Employee, etc..) for the model classes, which makes sense for me. I don't have any experience with LinqToSql, so I'm not sure if this is convention for LinqtoSql, or the way pluralization is working, or just some fundamental concept in LinqPad that I don't understand.

Anyway, thank you for the reply and the program, which I really like.

JoeAlbahari · October 2012

LINQPad pluralizes the collection properties if your table names are singular, but it doesn't attempt to singularlize plural names, because I never got round to writing a singularizer.

Pluralization and singularization is a function of the tooling. It's not really related to whether you use LINQ-to-SQL or EF.

Shawn · October 2012

Ah.. thanks Joe, makes sense to me now.

Inserting records

Comments