Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
697 questions
0 answers
Issues with EF Update Command and Azure Credentials in ASP.NET Core Application
I am encountering errors while attempting to run an Entity Framework (EF) update command (dotnet ef database update) from my ASP.NET Core application. The application is connected to a database hosted on Azure. After executing the EF update command, I am…
asked 2024-05-09T18:29:21.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 24%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYE%3C/text%3E%3C/svg%3E)
Yamen Edel
0
Reputation points
asked 2024-05-09T18:29:21.49+00:00
Yamen Edel
0
Reputation points
1 answer
I have been charged without my knowledge for the service that i did not use!
I have been charged without my knowledge for the service that i did not use. my number is #G047412504. it gives me error when i try to get refund. even though it displays that i am eligeable.
asked 2024-05-09T17:36:27.2166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 7.000000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mehmet Ali KABA
0
Reputation points
answered 2024-05-09T18:08:55.8766667+00:00
TP
76,846
Reputation points
1 answer
How to add Azure SQL Database as linked service to Azure Data Factory
I keep running into errors adding Azure SQL as a linked service to Data Factory. I'm new to Azure so please bear with me. Following all the online guides, I've done all of the following: On the SQL Server side: Under Microsoft Entra ID, enabled…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 44%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
0 answers
Error in Linked Service connected to azure sql db using Azure Key vault
The linked service is not working after performing CICD from dev to qa branch. All the resources are copied along with linked service. However, The linked service could not setup correctly with this error. What does this error indicate and how to…
asked 2024-05-09T15:16:14.0666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 71%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sudip Bala
0
Reputation points
commented 2024-05-09T16:40:26.5033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 81%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Marilee Turscak-MSFT
34,066
Reputation points Microsoft Employee
4 answers
CosmosDB Analytical store delete changes in sql sink
Hi I am trying to capture delete changes from Azure cosmosdb analytical store using change data capture in Azure datafactory, Source is Cosmosdb, sink is Azure sql database. In between I am flattening my file using dataflow. My insert, update is…
asked 2024-04-30T13:52:46.2133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 15%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Kuldeep Bhati
0
Reputation points
answered 2024-05-09T14:12:26.07+00:00
Kuldeep Bhati
0
Reputation points
2 answers
How to create and migrate the tables from one azure database to another azure database
Use-Case- I have 130 tables in the Azure sql database, I need to create and migrate the 130 tables to another azure sql database. Can I use the Azure data factory auto-create functionality to migrate those 130 tables. How the primary keys and indexes of…
asked 2024-05-08T08:29:13.6433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 68%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rahul
251
Reputation points
edited an answer 2024-05-09T13:29:04.32+00:00
Alberto Morillo
32,896
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Location 'southindia' is not accepting creation of new Windows Azure SQL Database servers for the subscription
I tried creating an Azure Synapse workspace. After clicking on the final 'review+create' option & it was getting deployed, I received an error (image below). However, I can see a storage account & a synapse storage account created. Only the…
asked 2024-05-09T10:11:51.47+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 22%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jeenia Bhadra
0
Reputation points
commented 2024-05-09T12:20:34.8966667+00:00
Jeenia Bhadra
0
Reputation points
0 answers
Unable to Modify innodb_dedicated_server variable in Azure Database for MySQL (Flexible Server) - Workarounds or Alternatives?
I'm trying to optimize performance for my Azure Database for MySQL (Flexible Server) instance. In my research, I found the innodb_dedicated_server parameter, but it's greyed out in the Azure portal, indicating it's non-modifiable,can i change this…
asked 2024-05-09T09:57:21.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 79%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Niket Kumar Singh
190
Reputation points
commented 2024-05-09T11:02:03.39+00:00
Niket Kumar Singh
190
Reputation points
2 answers
Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.
Error codeSqlFailedToConnect DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service…
asked 2024-05-04T23:34:12.1833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 44%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Albert Kirpach
0
Reputation points
commented 2024-05-09T09:35:58.83+00:00
MikeyQiao-MSFT
560
Reputation points Microsoft Vendor
3 answers
Azure workload move tenant to tenant
Dear All, we have existing tenant with listed below workloads and we are planning to move all these workloads to new tenant. what is the best way to move it with any production impact.
asked 2024-04-22T10:02:48.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 56.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rakesh Kumar
456
Reputation points
answered 2024-05-09T08:56:18.6533333+00:00
SadiqhAhmed-MSFT
38,321
Reputation points Microsoft Employee
1 answer
'Invalid column name 'is_change_feed_enabled'.'; detailedError - A database operation failed with the following error: 'Invalid column name 'is_change_feed_enabled'.'
When I tried to setup link connection between on-prem sql server and Azure sql dedicated pool, took the below error. Failed to enable Synapse Link on the source due to 'Failed to enable the source database: Some internal error happened due to 'Calling…
asked 2024-05-08T12:59:49.6566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 97%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AdmKaraH
0
Reputation points
answered 2024-05-09T06:22:38.51+00:00
AnnuKumari-MSFT
31,151
Reputation points Microsoft Employee
0 answers
User Managed identity with failover group with servers in different regions
while using user managed identity with azure sql , the connection string or token acquired using DefaultAzureCredential is dependent on the clientID of user managed identity. for the scenario when there is a sql failover switch i.e due to outage in one…
asked 2024-05-07T19:44:02.75+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 34%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
KAMALPREET KAUR
1
Reputation point Microsoft Employee
commented 2024-05-08T23:11:15.5166667+00:00
KAMALPREET KAUR
1
Reputation point Microsoft Employee
1 answer
Azure Management Instance Business Critical
Hi people, I have two questions about SQL Management Instance Business Critical. 1 - When I activate Zone Redundancy, I can't select which redundancy zone I want one of the nodes to be in? 2 - When I have zone redundancy in a failover with Business…
asked 2024-05-08T19:12:41.2266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 99%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Emerson Sousa
0
Reputation points
commented 2024-05-08T22:56:43.52+00:00
Oury Ba-MSFT
16,556
Reputation points Microsoft Employee
0 answers
ADF - CDC - enable and disable CDC tables during deployment
Hi, I have setup ADF pipeline for data sync of tables between Azure SQL Database to SQL Managed Instance databases. I am using Data Flow and CDC to track changes and sink activity to replicate it to target. However, when we deploy any table changes (add…
asked 2024-05-08T04:29:23.9233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 83%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ashwani SRIVASTAVA
40
Reputation points
commented 2024-05-08T22:23:19.7466667+00:00
Ashwani SRIVASTAVA
40
Reputation points
0 answers
Query to identify queries executed in a specific Azure SQL DB
Hi All, I am trying to monitor queries running on Azure SQL Databases on a Premium tier Elastic Pool with ReadScale replication enabled. We redirect reporting for our OLTP system against the replicas (using ApplicationIntent = ReadOnly) which means Query…
asked 2024-05-08T12:31:13.2233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 94%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Matthews, Darren (Capita Retain)
0
Reputation points
commented 2024-05-08T22:13:38.54+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee
0 answers
Writing an UPDATE SQL query in Azure Data Factory
I'm relatively new to ADF. We currently have a pipeline running that reads data from 5 separate csv files in blob storage, copies them to tables in Azure SQL database, and then calls 4 separate SQL server stored procedures which update, clean, and…
asked 2024-05-08T18:11:28.3966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 54%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
David Lang
0
Reputation points
edited a comment 2024-05-08T21:50:30.92+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
26,331
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Copying a Database to another logical server via the Portal
Copying a Database to another logical server does not show the available Elastic Pool in the destination when using the Portal. What is the reason for this?
asked 2024-05-07T16:32:39.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 22%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
Jon Josep
20
Reputation points Microsoft Employee
edited an answer 2024-05-08T20:25:48.38+00:00
Oury Ba-MSFT
16,556
Reputation points Microsoft Employee
0 answers
How do I download my app codes, and database, which are in Azure Cloud?
I need to download my app codes, and database, which are in Azure Cloud? Could anyone help me, indicating where are the tools for this? Thanks!
asked 2024-05-08T04:01:26.2366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 85%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Ramon Carrocino
0
Reputation points
commented 2024-05-08T20:14:55.36+00:00
Grmacjon-MSFT
16,191
Reputation points
1 answer
Unable to find package 'Microsoft.Azure.SqlDatabase.ElasticScale.Service.SplitMerge'
It is related to "Deploy a split-merge service to move data between sharded databases" I followed the steps in the "Download the Split-Merge packages" (very beginning) and tried to execute the command nuget install…
asked 2024-05-02T16:29:54.73+00:00
Ho Ming Tam
45
Reputation points
commented 2024-05-08T19:14:42.0133333+00:00
Ho Ming Tam
45
Reputation points
2 answers
ASD: How can I determine replica name from info in sys.dm_database_replica_states?
I have named replicas (NOT availability replicas) in my Azure SQL Database instance. When retrieving information from sys.dm_database_replica_states (generally to check secondary_lag_seconds), how can I determine the replica name associated with each…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,169 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
967 questions
asked 2024-05-07T14:04:13.9166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 74%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Joseph Harris
0
Reputation points
edited an answer 2024-05-08T11:19:00.43+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee