Entity Framework 6 - Knowledge Base (KB)
40 results in tag: azure-sql-database
How can I fix Azure? "This version of SQL Server does not allow Windows logins"?
I get the following error message, when I try to connect to SQL Azure....Windows logins are not supported in this version of SQL Server...I'm using an Azure connection string. On development I'm running against SQL Server Express. This specific error is t...
asked by Just2Click
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
How to reset identity seed in Sql Azure
I have tried the following in order to reset my Identity Seed of a column:...DBCC CHECKIDENT ('dbo.Stuff', RESEED, 0) ...This does not work in sql azure, I was wondering what would be the best way to go about doing this. Drop and recreate table?
asked by anthonypliu
Entities Framework 6 alpha 2 - Async Patterns
I recently have a project with MVC 4, .NET 4.5 and using EF 5.0 (Database First) using the EF 5.0 DbContext Generator. I then upgraded through Nuget Manager to EF 6.0 alpha 2. I wanted to use the new async patterns but for some reason I dont have .ToLis...
asked by Joe
EF 6 System.Data.Objects.ObjectContext Error
I recently upgraded from Entities Framework 5 to Entities Framework 6 Alpha 2 and I am getting the following error:...Method not found: 'System.Data.Objects.ObjectContext System.Data.Entity.Infrastructure.IObjectContextAdapter.get_ObjectContext()'....Th...
asked by Joe
Error deploying to SQL Azure using EF 6 alpha3 Code First and Migrations creating __MigrationHistory table
I'm using EF 6 alpha 3 code first. When I try to create the database on SQL Azure running the Update-Database command I get the following error:...Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered ...
asked by Bruno Moscão
Lazy vs eager loading performance on Entity Framework
So I have the following model classes on my DbContext:...Everytime I render a list of LoanApplication objects I do something like this:...var context = new MyContext(); var applications = context.LoanApplications.Where(d => d.PropertyThatIWantToFilter = l...
asked by amhed
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
A network-releated or instance-specific error occurred while establishing a connection to SQL Server
I have a simple mvc web site (using the VS internet template) on azurewebsites talking to a SQL Azure database in the same data center. The database at this time is just to do the built-in SimpleMembership Provider. I have already switched from the defa...
asked by Old Geezer
EF6 executing a long running stored procedure gets timeout errors
I recently upgraded my project from EF5 to EF6. In this project I have an Azure Worker Role that runs periodically, and kicks off a stored procedure on SQL Azure that updates a bunch of database information, and takes on average 1.5 hours to execute. When...
asked by CodeGrue
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
How to test if database is hosted on SQL Azure?
Is it possible to test whether a database is hosted on SQL Azure? I am looking at SqlAzureExecutionStrategy for EF6 and only want to apply if the database is actually SQL Azure database....Currently I am testing if App is running within Azure. However we ...
asked by GraemeMiller
Stored procedure working when calling exec sp and throws with EF6 on SQL Azure
I have this stored procedure...CREATE PROCEDURE [dbo].[sp_RebuildIndexes] AS BEGIN DECLARE @TableName varchar(255) DECLARE TableCursor CURSOR FOR (SELECT '[' + IST.TABLE_SCHEMA + '].[' + IST.table_name + ']' AS [TableName] FROM INFORMATION_SCHE...
asked by JuChom
Error While Enabling Code-First Migrations On Mobile Services Database
I have an Azure Mobile Services project (C# backend) that I recently created and attached to an Azure SQL database. I have been trying to enable Code-First Migrations on that backing database, but it throws errors when I try to update the database....I ra...
asked by Wasabi Fan
Parallelization of queries using multiple Entity Framework contexts
Consider the situation where I need to perform and combine the results of several isolated queries from the database. Each individual query is based on a parameter, which is supplied from elsewhere....One way would be to perform these queries sequentiall...
asked by Dave New
"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
Entity Framework 6 Model-First - Update Production Database Based On Local Changes
I'm new to EF and inherited a project that apparently used database-first development....The production environment uses SQL Azure and I'm basically trying to figure out the standard approach for updating its schema. ...At first, I tried enabling migratio...
asked by Colin
SetExecutionStrategy to SqlAzureExecutionStrategy with DbMigrationsConfiguration?
I saw a post today about implementing SqlAzureExecutionStrategy:...http://romiller.com/tag/sqlazureexecutionstrategy/...However, all examples I can find of this use a Configuration that inherits from DbConfiguration. My project is using EF6 Code First Mi...
asked by James in Indy
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
