Connecting to Sql Azure with Entity Framework "Code First" ctp 5

Question

Is it possible to connect to Sql Azure with Entity Framework "Code First" ctp 5? I keep getting a:

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible." ..message.

I know my connection string is correct because I can connect to the database with server explorer in Visual Studio.

I tried connecting to an existing database and creating a database first, both return the same message.

Also, everything works if I use a local database (sqlexpress).

Lee Smith · Accepted Answer · 2012-05-12 21:37:34Z

2

I was passing the name of the connection string into the constructor instead of the connection string name. If you do this, I think it automatically creates a new sqlExpress connection. This may be because I placed the connection strings in the web.debug.config and web.live.config and it couldn't resolve them.

edited May 12, 2012 at 21:37

answered Jan 11, 2011 at 11:47

Lee Smith

6,8316 gold badges31 silver badges36 bronze badges

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

Comments

Igorek · Accepted Answer · 2010-12-13 00:14:31Z

0

SQL Azure does not support (or to be more precise give access to) all of the system stored procs and other commands that regular SQL server or SQL Express support and open up to. You will find SQL Azure somewhat constraining when it comes time to managing it.

What you want to do is create your database locally and then migrate it over to SQL Azure using either RedGate's SQL Compare beta for version 9.0 found at: http://www.red-gate.com/Azure or use SQL Azure migration wizard found at: http://sqlazuremw.codeplex.com/

answered Dec 13, 2010 at 0:14

Igorek

15.9k3 gold badges60 silver badges94 bronze badges

1 Comment

Lee Smith Over a year ago

Thanks, but migration is not a problem. I can create the database on azure and connect to it - I just can't connect to it using EF Code first (cpt5).

Derek Beattie · Accepted Answer · 2011-01-07 23:54:27Z

0

I'm having the same problem, not connecting to azure though. This question came up in my search. I have code first working fine with my local SQLExpress instance but when I try and connect remotely to another server running SQL2008R2, I get the same error. I can however, in the same code I'm using CF CTP5, connect with the same ConnectionString using straight ADO.NET.

answered Jan 7, 2011 at 23:54

Derek Beattie

9,4784 gold badges33 silver badges45 bronze badges

2 Comments

Derek Beattie Over a year ago

I finally got this working, try passing the ConnectionString in the DbContext constructor instead of the name of the ConnectionString in the .config file.

Derek Beattie Over a year ago

I'm incorrect, it resolves the ConnStr by name fine, I had a mismatch.

Collectives™ on Stack Overflow

Connecting to Sql Azure with Entity Framework "Code First" ctp 5

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related