ServerVersion' threw an exception of type 'System.InvalidOperationException'

Question

0.00/5 (No votes)

See more:

Hi
Im trying to get Asp.Net Identity to work with Entity Framework.

But im not getting that far.
Every time I call

C#

FootModelEntities aa = new FootModelEntities();

And then I check the Connection and noticed

XML

ServerVersion = '(((System.Data.Entity.DbContext)(aa)).Database.Connection).ServerVersion' threw an exception of type 'System.InvalidOperationException'

Why is that happening?
I have been google`ing and cant find any help.
Im using Entity framework 6, SQL Server 2012

Thanks
Jakob

Posted 2-Jul-14 5:07am

jakobvjensen

Add a Solution

Comments

johannesnestler 2-Jul-14 14:54pm

does the Connection not work, or is this just what you see while debugging?

jakobvjensen 2-Jul-14 15:04pm

The connection not working..
But think maybe i know what the problem is.. I started the project as model-first, then i added some tables and updated the designer from database. And i think its where the problem started

johannesnestler 3-Jul-14 13:15pm

hmmm - if you can synchronize the changes between your database and model it should work again - no matter how you manage that. OT: I like to do the mapping "manually" in code - much less headaches in the long run, and I don't want to mess arround with T4's...

jakobvjensen 4-Jul-14 0:33am

I manage to found out what the problem was.. It was because i did'nt made my controller action async, and had the call await.. So now its working..
I would also like to manage relationships in code. But after i looked at the modelbuilder in the OnModelCreating im worried that i miss something if i write that myself.. I have also seeing a lot of examples on the internet that are very different from each other and also very different than the code that EF auto generate

johannesnestler 4-Jul-14 4:13am

Nice to hear you solved your problem. I see the most benefit in doing the mapping in code when it comes to relations - in some cases (I have to work with DB-First...) the automatic mapping is impossible and you have to code it anyway. But you are right it takes sometime to learn it - but the fluent syntax is very cool and maintainable (and in doubt just generate it, and have a look how the generated mapping code works). But it depends on the type of projects you work on if the manual approach is the right one. If database is heavily normalized and "big", configuration (and maintaining it) is a nightmare, you end up with generated mapping, edited model configurations, coded mappings all together. With code I feel I have the total control and nothing "magically" changes :-)

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)