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...
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)]
...
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...
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?
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...
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...
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 ...
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...
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; }
}
...
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...
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...
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 ...
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 ...
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...
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...
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...
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...
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...
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...
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...