Entity Framework Core - Knowledge Base (KB)
38 results in tag: azure-sql-database
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
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 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
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
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
How to programatically create Sql Azure database of type Basic/Standard edition through Enity Framework code first
I use EF 6. My existing code is : ...public void CreateOrUpdateCompanyDb(string companyDbName) { try { string connectionString = _connectionStringProvider.GetConnectionString(companyDbName); DbMigrationsConfiguratio...
asked by Ognyan Dimitrov
How to use SqlAzureExecutionStrategy and "Nolock"
To deal with SQL timeouts I'm trying to use SqlAzureExecutionStrategy (...https://msdn.microsoft.com/en-us/data/dn456835.aspx...) ...The problem I am running into is it prevents "user initiated transactions" which seem to be the recommended way to impleme...
asked by Aaron Sherman
Change the connection string dynamically (per request) on Entity Framework 7 / MVC 6
I have a MVC 6 application on which I need to connect to a different database (i.e. physical file but same schema) depending on who is accessing to it. That is: each customer of the web application will have it's data isolated in an SQL database (on Azure...
asked by Vi100
Entity Framework - how to avoid query recompilation?
I am working on optimization of our Entity Framework code, and currently I am facing an issue I'm not sure how to solve....We are using ...Azure SQL... + ...Code-First Entity Framework 6.1.3... + ...Asp.net Web Api v2.... Endpoint is hosted in the cloud a...
asked by Red
EF Core and SqlAzureExecutionStrategy
I've tried to have a search for anything related to a SqlAzureExecutionStrategy for EF core and came up empty handed....Does anyone have any information around the need for setting an execution strategy when using EF Core and SQL Azure?
asked by sf.
Azure SQL set default Collation
The default collation for Azure SQL is SQL_Latin1_General_CP1_CI_AS, not too good if your language has accents or diacritics and you want to ignore them. Everytime I want to deploy a web application with database to Azure I'm forced to create the database...
asked by Vi100
How to publish database to Azure using Visual Studio Code on Mac?
I built asp.net MVC Core web app using Visual Studio Code on Mac. The app is working with database (EF) in localhost all along....I have an Azure account with Web App + SQL Database created. Then I have changed the connection string in ...appsetting.json....
asked by Matt
EF migration with new table collation error
I'm using Entity Framework code first, It has been working ok updating the database with db migrations up until recently......I've added a anew property to the AspNetUser table...public partial class AspNetUser { .... public ICollection<Feed> Feeds { get...
asked by raklos
EF Core: An exception occurred in the database while iterating the results of a query
I'm getting this error from my web app hosted in Azure. It runs ok for a few days and then suddenly stops working....Is there an issue with the connection perhaps? Which object reference does not have an instance?...YYYY-MM-DD hh:mm:ss [Error] An exceptio...
asked by Jonas Arcangel
Intermittent error with EF Core: The connection does not support MultipleActiveResultSets
I have an ASP.Net Core application that uses EF Core....I use ASP.Net Identity and share the same DBContext for my app's entities....I have set my connection string to an Azure SQL database to have MultipleActiveResultSet=True....It works for a day or two...
asked by Jonas Arcangel
Invalid Object Name Error - EntityFrameworkCore 2.0
Howdee, I'm having an issue with entity framework telling me that the objects don't exist on my database when they do exist and I have mapped the names using the .ToTable method. Below is how I'm injecting the context into my controller:...In Startup.cs =...
asked by Clouse24
Connect to Azure SQL server via AAD Authentication using EF Core
Azure SQL servers support AAD authentication, and I want my applications to connect to SQL server using AAD authentication and not SQL server admin credentials. I am using EF core to connect to SQL, how do I enable EF Core to use AAD authentication....My ...
asked by Pratik Bhattacharya
Parameterised OFFSET FETCH NEXT query (EF Core) has 10x slower performance
I'm running the following query through (generated by Entity Framework Core) Microsoft SQL Server Management Studio against a SQL Azure database table with ~46,000 rows which takes ~5seconds...DECLARE @__TypedProperty_0 as int = 20 DECLARE @__TypedPropert...
asked by Henry Ing-Simmons
Code First Update-Database Keyword Not Supported
I am using the following connection string (from the "Show database connection strings" option in the Azure portal") to connect to an Azure SQL database;...services.AddDbContext<PwttContext>(options => options.UseSqlServer("Server=tcp:<serverName>.databas...
asked by Ray