Entity Framework 6 - Knowledge Base (KB)

How do I set an ADO.NET Entity Framework connection string via the Windows Azure (Preview) Management Portal?

In the Windows Azure (Preview) Management Portal you can change the configuration options for web sites (see ...http://www.windowsazure.com/en-us/manage/services/web-sites/how-to-configure-websites/#howtochangeconfig...)....I currently set the connection ...

How do you tell entity framework to create / deploy a database in Azure?

I'm using Entity Framework with a code first model; I've got my InitialCreate migration setup and working locally, I can run code against my database context, and everything works....But when I deploy my project to Azure, I just get a connection string er...

The entity type ApplicationUser is not part of the model for the current context. Used two different databases at beginning of project

I've created an MVC 4 application using entity framework to read and write data to a database I am hosting on an Azure database. The Azure database was supposed to keep the application data AND the login data for the application. ...However, when I first...

Connect to Azure SQL using Azure Active Directory from an Azure Website?

A have an Azure Website running which connects to an Azure SQL through Entity Framework 6. Everything runs and I'm using standard username/password (sql login) to connect. ...Now, I would like to switch over to using AAD for authenticating to sql. I alrea...

Rows were detected. The schema update is terminating because data loss might occur

I am developing a web application and of course on each phase I need to change the database schema on test server. When I tried to publish my code to my azure app service, it showed me an error:...Error : .Net SqlClient Data Provider: Msg 50000, Level 16,...

Entity framework Slow query performance

I am using Entity framework 6.2.0 with WebAPI hosted on azure app service....My database is not big with only two tables and I have a simple select query...Account account = Db.Accounts.Where(p => p.Code == Code && p.PersonId == PersonId).Include("Optio...