New answers tagged c#
I don't know which data access technology you are using, but certainly in plain ADO.NET it's definitely a supported feature to have queries that return multiple resultsets. For example, if you have a SqlDataReader, you step through the resultsets with NextResult. It would then be a straightforward matter to read each of the three resultsets in turn and see ...
Create a set of staging tables in the target database. Write rows to these as they are generated, which seems to be one or two at a time. This can be inside a transaction. Once the whole batch (200 rows?) is in these staging tables use a stored procedure in the target database to move them en masse from the staging tables to the real ones.
I've seen similar problems addressed by decoupling the app from the central server: Remote sites install a local SQL Server Express along with the app Apps talk to the local Express instance. Low latency, good availability. SQL Server Express uses Service Broker to deliver the updates to the central server Service Broker handles the network availability, ...
found it. turns out the permissions command I was using isn't enough for a restore (it's enough for the backup). Granting the full access rule on the folder isn't enough - it has to be on "the folder, subfolders and files". basically two more lines of code: myDirectorySecurity.AddAccessRule(new FileSystemAccessRule(sqlserviceuser, ...
Top 50 recent answers are included