Geek Answers Handbook

Starting line of EF 4.1 code in web.config

Today is my nightmare day. I am successfully working on code development at the local level, and everything goes well when my db is discarded and recreated as necessary when changing the model. However, trying to "upgrade" the project to the sqlserver2008 intermediate server on mydiscountasp.net, my problems started in earnest. Since the sharing databases cannot be deleted / recreated by the user, I took a local backup and restored it to the server. One step closer. I see the database when I enter the server through sqlserver mgt studio and everything looks fine. However, I cannot figure out how to connect to the database through web.config. I started using the modest sysntax ado.net for a connection string line by line:

<add name="MyWebSiteContext" connectionString="Server=esql2k123.discountasp.net; Database=SQL2008R2_123456_test;uid=SQL2008R2_123456_test_user;pwd=mypassword;" providerName="System.Data.SqlClient"/>

this did not work and gave an error saying that the keyword "server" was not recognized. after a lot of searching, it looks like the problem might be related to the providerName="System.Data.SqlClient" .

So, changing this to providerName="System.Data.EntityClient" , I was a little scared. Alas, the same story.

To shorten the (very) long history, I have tried many permutations (mutations are the operational word !! :)), but it may not seem that they meet the correct syntax requirement for the first ef connectionstring requirement.

Has anyone there recently gone through a similar hoop and found a working solution?

fingers, fingers and eyes xx'd ..

[UPDATE] I managed to get my connection string to work (ALMOST) by formatting it like this:

 <add name="GBCWebSiteContext" connectionString="Data Source=esql2k123.discountasp.net;Initial Catalog=SQL2008R2_123456_test;Persist Security Info=True;MultipleActiveResultSets=True;User ID=SQL2008R2_123456_test_user;Password=mypass" providerName="System.Data.SqlClient"/>

Now I can stop and debug the action of the controller, as it performs linq selection. HOWEVER, when I try to return the rows, I get an exception that states: The trigger returns a result set, and the server parameter "disable results from triggers" is true

So, what is my last piece of the puzzle here, is an extra option in the connection string to negate this problem?

[UPDATE 2] Hallellulah - I chopped a nut. Since I relayed the global.asax line:

 Database.SetInitializer(new System.Data.Entity.DropCreateDatabaseIfModelChanges<MyWebSiteContext>());

I did not understand that I need to include a null reference to Database.SetInitializer() .

So here is the following sorting of my problem:

 Database.SetInitializer<MyWebSiteContext>(null);

Thanks to everyone for the various suggestions, they helped me focus on the problem. So happy :)

+4
source share
3 answers

So, essentially, the answer to my problem was twofold:

  • the connection string should be line by line (just by inserting information about the connection strings, everything else remains the same as above):

    connectionString = "Data source = esql2k123.discountasp.net; Start directory = SQL2008R2_123456_test; Persist Security Info = True; MultipleActiveResultSets = True ; User ID = SQL2008R2_123456_test_user; Password = mypass"

  • In the global.asax Application_Start application (or, as is the case with my application, ninject OnApplicationStarted ()), you must have the null Database.SetInitializer<>() function to restore the existing ones:

Database.SetInitializer(new System.Data.Entity.DropCreateDatabaseIfModelChanges<MyWebSiteContext>());

caused a problem. Replacing this with Database.SetInitializer<MyWebSiteContext>(null);

fixed wholesale problem.

Thank you for sharing your trip and your thoughts, and hopefully this will serve as a starting point for anyone who has similar problems.

+2
source

Have you tried the data source and start directory?

 sqlConnectionString="data source=myServer.myDomain.com;initial catalog=mydbName;user id=myUid;password=myPwd"
+2
source

Is the database server and web server in the same environment? Have you tried Server=localhost; instead of Server=esql2k123.discountasp.net; ?

Or, alternatively, can you find out what IP address on the database server exists where the web server is?

+2
source

More articles:


All Articles