Entity Framework 6 - Knowledge Base (KB)
46 results in tag: azure
First Azure connection using Entity Framework code
I am using Entity Framework Code First 4.3 + Azure and having difficulties connecting to the database. The error I get is the following (on the first query):...Keyword not supported: 'server'. ...I have the following connection set up in my Web.config...<...
asked by Stefan Szasz
A good example of using WPF, WCF, and Entity Framework together.
I am planning on creating a new data-driven Client/Server application with the flexibility to have WPF, Silverlight, and mobile clients. I am already well versed in WPF and need to learn how to implement the back end. Everything I've read is pointing me...
asked by Trevor Elliott
Code First Entity Framework and Windows Azure SQL
I am trying move a very simple code first example from my local SQL on to Azure SQL and as it appears I've hit a brick wall....This is the simple code that I am using:...public class Cat { [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)] ...
asked by Jammer
Handshake exception occurring when connecting to SQL Server Azure with .NET 4.5
So I opened up some code that hasn't been touched in about 2 months. ...Last time I opened the application all unit tests passed. Now with no code changes all my data unit tests fail with the following error: ...Initialization method PerTrac.Pictor.Data...
asked by BentOnCoding
'Microsoft.SqlServer.Types' version 10 or higher could not be found on Azure
I'm trying to make a webapi in ASP.NET MVC 4. The webapi used Entity Framework 5 Spatial types and i have wrote a very simple code. ... public List<Area> GetAllAreas() { List<Area> aList = db.Areas.ToList(); return aList; } ...Are...
asked by Thomas Bolander
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 ...
asked by Frank van Eykelen
How to make Entity Framework Code First use the SQL Azure DB?
I'm start to learn EF now. What I want to do is use EF code first create new tables in SQL Azure....Here is my code:...namespace WebApplication2 { public class Blog { public int UserName { get; set; } public int ID { get; set; } } ...
asked by EthenHY
Failed to find or load the registered .Net Framework Data Provider with MySql + MVC4
We are getting the following error when we tried running our MVC4 Project with Azure Mysql DB. ...In Web.Config file we have the following,...<DbProviderFactories> <remove invariant="MySql.Data.MySqlClient" /> <add name="MySQL Data Provider" i...
asked by Wizer
Entity Framework 6.0 Code First Migrations to Azure SQL DB not working.
I am trying to create an ASP.NET MVC site loosely based on this tutorial. ...http://www.windowsazure.com/en-us/develop/net/tutorials/web-site-with-sql-database/...I am using VS2013 preview which gave me the option to create an ASP.NET MVC 5 site. Also, u...
asked by Carlos Nuñez
Details of customizing ASP.NET Identity (OWIN) use of Entity Framework
This blog:...http://blogs.msdn.com/b/webdev/archive/2013/06/27/introducing-asp-net-identity-membership-system-for-asp-net-applications.aspx...about the ASP.NET identity provider states:...Persistence control...By default the ASP.NET Identity system will s...
asked by BenjiFB
Code First & Identity with Azure Table Storage
I'm working on a small web app and I've just hit the point in development where I need to start making database decisions. My original plan was to go EF Code First with MSSQL on Azure because it just simplifies the process of working with a database. Howe...
asked by Dragonseer
Azure + EF 6 - Making code first migrations work
I am using EF 6 (code first with migrations) for MVC 5 project. On my local DEV machine everything works fine....But when I deploy my project to Azure, I get the following error when my app first tries to interact with the database:...Migrations is enable...
asked by Moon
How to re-create database for Entity Framework?
I have got into a bad state with my ASP.Net MVC 5 project, using Code-First Entity Framework. I don't care about losing data, I just want to be able to start fresh, recreate the database and start using Code-First migrations. ...Currently I am in a state ...
asked by Toby Sharp
ApplicationUser - how do I use it? what do I need to put in my using clauses?
I am trying to follow this tutorial but I'm stuck in the area where it tries to add ApplicationUser based code. The roles section....dotnet deploy db based MVC site to azure...I did include these lines:... using Microsoft.AspNet.Identity; using Micros...
asked by Neo42
The model backing the '--Context' context has changed since the database was created - but db is new production database
I've got this error for the 762nd time but this time I am getting it as soon as I attempt to access my Production site, straight after deleting the 'production' database on Azure and then publishing my site....The model backing the 'PropertyContext' conte...
asked by stuartdotnet
How do I encrypt data in Entity Framework Code First?
I've been trying and failing to figure out a good approach to encrypting SQL data with the Entity Framework Code First. I must preface this with that I am hosting in Azure and do not have access to native SQL encryption....Taking a page from ...SecurEntit...
asked by Albert Bori
EF6 and azure worker role : underlying provider fail on open
I’m struggling with EntityFramework 6 and a PaaS architecture. I have a repository project that calls a DAL project to execute some EF6 imported stored procedures. Until recently we were going for a IaaS architecture but for some reasons we switched to ...
asked by Quentin
"The semaphore timeout period has expired" SQL Azure
I am running a .Net MVC Azure Web Site with a SQL Azure database accessed using Entity Framework 6. Intermittently (1 in a thousand or so requests), I get the error "System.ComponentModel.Win32Exception: The semaphore timeout period has expired" ...Syst...
asked by AlexC
Connecting to Azure DB from Cloud Service utilizing Entity Framework
I am trying to connect to an Azure SQL Server database from an Azure Cloud Services project through entity framework, but am getting an error of "The underlying provider failed on Open."...I repeated the same process of adding entity framework which I too...
asked by user3648426
MVC 5 - The type arguments for method "..." cannot be inferred from the usage. Try specifying the type arguments explicitly
I have been learning MVC 5 for the past couple of weeks. I have had little to no issues so far, until yesterday. Everything was working fine until last night when I opened up VS to work on my projects some....My issues:...To get a few things out of the wa...
asked by Jonathan Carroll
