LinqPad ChangesNames

osorojo

I'm working through my first query with LinqPad. It's a connection to a SQl Server database from one of our vendors. I'm using a table called Employee in SQL Server, but I notice that LinqPad calls it Employees plural. There is a primary key field in the table I need for linking that is also called Employee, but LinqPad calls it Content.

What is going on here? Do I have to modify all my queries after I development in LinqPad because it didn't like the field names?

Bernie

JoeAlbahari

You can disable pluralization - right-click the and choose Properties.

When conflicts occur, LINQPad uses heuristics to rename columns, and also to determine association names. These won't also be the same as the heuristics that Visual Studio's LINQ-to-SQL and Entity Framework designers use. If you need compatibility with a typed data context that you've created in VS, you can click the option to connect to a typed data context in your own assembly.

osorojo

"you can click the option to connect to a typed data context in your own assembly."

How do I do this?

JoeAlbahari

Are you using LINQ to SQL or Entity Framework?

If you're using Entity Framework, a tutorial is here:
http://www.linqpad.net/EntityFramework.aspx

NetMage

"You can disable pluralization - right-click the and choose Properties."

What do you right-click?

JoeAlbahari

Right-click the connection in the treeview on the left.