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

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 ...
azure-sql-database entity-framework entity-framework-6
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...
azure-sql-database entity-framework entity-framework-6
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 ...
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

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

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

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...
azure-sql-database ef-code-first ef-migrations entity-framework entity-framework-6
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...
azure azure-sql-database entity-framework entity-framework-6 linq
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...
asp.net-core asp.net-core-mvc azure-sql-database entity-framework-core
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...
azure azure-sql-database c# entity-framework entity-framework-6
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?
azure-sql-database entity-framework-core
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...
azure-sql-database entity-framework-core
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....
asp.net-core azure azure-sql-database entity-framework-core visual-studio-code
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...
azure-sql-database database-migration ef-migrations entity-framework entity-framework-6
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...
asp.net-web-api azure-sql-database azure-web-sites entity-framework-core
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...
asp.net-core azure-sql-database entity-framework-core
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 =...
azure-sql-database c# entity-framework-core
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 ...
azure-active-directory azure-sql-database azure-sql-server azure-web-sites entity-framework-core
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...
azure-sql-database entity-framework-core sql
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...
azure-sql-database connection-string entity-framework-core
asked by Ray

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
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!