EF Code first existing SQL Azure Database

Question

I successfully created database on my local server using Code First, migrated it to Azure and now I want to connect to that database with using Azure connection string and my existing POCO clases.

My connection string:

<add name="CijenolomciContext" connectionString="Data Source=*.database.windows.net;Initial Catalog=NewCijenolomci;Persist Security Info=True;User ID=Bip*;Password=**;MultipleActiveResultSets=False&quot;" providerName="System.Data.EntityClient" />

but this section of code happens to do nothing on the server:

Item i = new Item();
            i.Name = "Cranberry";
            i.OldPrice = new decimal(25.99);
            i.NewPrice = new decimal(14.99);
            i.SaleStarts = DateTime.Parse("2012-01-21");
            i.CategoryID = 1;
            context.Items.Add(i);
            context.SaveChanges();

How to succesfully add it?

EDIT: This approach happens to modify my local DB, not the Server one.

Mike Sherrill 'Cat Recall' · Accepted Answer · 2012-03-23 13:01:57Z

1

It doesn't look like you're connecting to an Azure database to me. I'd expect a connection string more like this.

Server=tcp:[serverName].database.windows.net;Database=myDataBase;User ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False;Encrypt=True;

Use 'username@servername' for the User ID parameter.

See Connection Strings for SQL Azure.

answered Mar 23, 2012 at 13:01

Mike Sherrill 'Cat Recall'

96.6k20 gold badges134 silver badges195 bronze badges

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

2 Comments

Bip Over a year ago

Whell i use this kind of connection string and it keeps to add to local DB :/

Bip Over a year ago

It may be because i inherit the base constructor in DbContext, but now when i change it i get System.ArgumentException: Keyword not supported: 'server'.

Bip · Accepted Answer · 2012-03-23 13:46:24Z

0

OK. Here it is. In DbContext i inherit base constructor:

 public CijenolomciContext()
        : base(*database name*)
    {
        //additional logic
    }

and despite that i add my connection string in App.config he was always connecting to the local.

I hardcoded Connection string and just add it in the constructor. Now it works! :)

answered Mar 23, 2012 at 13:46

Bip

9135 gold badges14 silver badges29 bronze badges

Collectives™ on Stack Overflow

EF Code first existing SQL Azure Database

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related