Category: sql-server

Creating SQL Server backup file (.bak) with c# to any location

I’m trying to write simple application in C# which will allow me to backup, zip and send over ftp my SQL Server database. One problem I have encountered is that I’m not able to create the backup file (.bak) if I try to do it in different location than “C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Backup” or “C:\Program […]

Combining SQL results using LINQ

I have a database of company registrants (for a search/directory functionality). We’ve added a new table to hold “enhanced” information for registrants that pay for this feature (such as advertisements/additional images/logos etc). Right now the new table just holds the registrants unique identifier, and a few additional fields (paths to images etc). A user can […]