zzz projects Entity Framework 6 EF 6
Home EF Core Articles Knowledge Base Online Examples
  • Home
  • EF Core
  • Articles
  • Knowledge Base
  • Online Examples

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...
asp.net-mvc azure-sql-database c# entity-framework sql-server
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)] ...
azure azure-sql-database code-first ef-code-first entity-framework
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...
.net azure azure-sql-database entity-framework sql-server
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?
azure-sql-database c# entity-framework sql
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...
asp.net-mvc asp.net-mvc-4 azure-sql-database c# entity-framework-6
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...
asp.net-mvc asp.net-mvc-4 azure-sql-database c# entity-framework-6
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 ...
azure-sql-database entity-framework entity-framework-6
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...
asp.net-mvc azure-sql-database c# code-first entity-framework
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; } } ...
azure azure-sql-database c# ef-code-first entity-framework
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...
asp.net-mvc azure-sql-database azure-web-roles connection-string entity-framework
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...
azure-sql-database entity-framework entity-framework-6
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 ...
asp.net-mvc azure azure-sql-database entity-framework
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 ...
azure-sql-database entity-framework entity-framework-6 sql-server
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...
azure-sql-database c# entity-framework entity-framework-6 stored-procedures
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...
azure-sql-database c# ef-code-first entity-framework sql
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...
.net azure-sql-database c# entity-framework entity-framework-6
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...
asp.net-mvc azure azure-sql-database entity-framework
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...
azure-sql-database ef-database-first ef-model-first entity-framework entity-framework-6
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...
azure-sql-database ef-migrations entity-framework entity-framework-6.1
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...
azure azure-cloud-services azure-sql-database entity-framework-6
asked by user3648426

Page 1 of 2
  • 1
  • 2
  • »

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!