Entity Framework 4: Invalid Column Name

Question

I know there are a lot of questions like this asked, but I can't seem to find one that fits my scenario. I'm using Entity Framework, Database First (my database already existed when I decided to start using EF). I'm creating my edmx file, loading the correct tables into my model. However, I keep getting an "Invalid Column Name" error when I try to perform a query for a specific table through Entity Framework.

Using SQL Server Profiler, I see that the query is syntactically correct (I can run the query myself through SQL Server Management Studio), so I have no idea why this could be happening.

Any ideas? Thanks in advance.

EDIT: This isn't a SQL Exception, it's a System.Data.EntityCommandExecutionException

Pedro Matos · Accepted Answer · 2014-07-07 14:46:23Z

3

What happened to me, in the past, is that I had a database locally with the column, and then, after testing the application the connection string was pointing to another database in which the new column was absent.

Is that the case?

You can always check if the connection you are using (when playing the app) is the same as the one you are generating your edmx file to make sure.

answered Jul 7, 2014 at 14:46

Pedro Matos

3872 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Carlos Rodriguez Over a year ago

I thought this might be what was happening, but I've ensured that all the config connection strings are pointing to the correct database.

Carlos Rodriguez Over a year ago

Ugh, didn't update the one place where it mattered. In My Web.config lol. Thanks!

Collectives™ on Stack Overflow

Entity Framework 4: Invalid Column Name

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related