We upgraded Entity framework in a .NET Core project to 7.0 and suddenly inserts into a SQL Table were no longer working – nothing got inserted and there was no error. Let’s check the breaking changes document: https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-7.0/breaking-changes SQL Server tables with triggers or certain computed columns now require special EF Core configuration Old behaviorPrevious... » read more
If you have a bunch of databases that you want to migrate into a single Azure SQL DB, and the table names are all different then that’s quite easy. If you don’t mind renaming things, then there’s a solution for same-named tables too… Add/migrate one database Head over to the Azure SQL section https://portal.azure.com/#create/Microsoft.AzureSQL Create... » read more
With this error: Error inserting data into table. (Microsoft.SqlServer.Import.Wizard)Error inserting data into table. (Microsoft.SqlServer.Prose.Import)Object reference not set to an instance of an object. (Microsoft.SqlServer.Prose.Import) In my case this was due to extra carriage returns at the end of the CSV file – SSMS doesn’t like them! Remove them in a text editor and try again.... » read more
There’s a bunch of info on this already out there, but this is pretty specific – we have an existing set of Microsoft SQL Server databases on an AWS instance and I needed to connect to them in a new WebApp service. Here’s how I did it. This assumes you have an Azure account all... » read more
After our server people did some MS SQL database restores from some old backups to find some data, some .NET websites we had on the server started showing an error. (note I couldn’t see the error and had to disable custom errors from remote only, see here http://tech.ralpharama.co.uk/1/viewing-errors-remote-machine-after-sql-restores-broke-sites Server Error in '/' Application. Cannot open database... » read more