Connect To SQL… a utility for C# programmers–Part 3

Just a quick note to let everyone know that the code has been published on CodePlex Simply search for ConnectToSQL or go to the project’s home page at www.cts.codeplex.com

0

Connect To SQL… a utility for C# programmers– Part 2

Today we will examine the code that connects to our database and showcases the code used to determine the correct Authentication method 1: Cursor current = Cursor.Current; 2: Cursor.Current = Cursors.WaitCursor; 3: // Create our connection information for use by the Results Form 4: ServerConnection sc = new ServerConnection(ServerName); 5: // Create a ConnectToSQLBase object…

0

SqlCommandFilters–a tool for every toolbox

SqlCommandFilters is a utility assembly that will automatically parse your SqlCommand.CommandText and parameterize it for you. Why would you want to do this?   Picture this  You want to leverage SQL Server Always Encrypted, but you your queries are not currently parameterized You have a web application that builds all SQL input from elements on…

0

Connect To SQL… a utility for C# programmers

You are writing a tool for SQL programmers by using C#, SQL Management Objects etc. You need to connect to a SQL Server instance and so you need to code a way to ask for the Server name, user credentials and so on. Why rewrite it each and every time? Simply add boB ‘The Tool…

3

It’s been awhile…

I have started a new role as a Data Platform Solution Architect in the Health and Life Sciences vertical at Microsoft. Its been hectic, but fun. I am finally getting a bit of time to work on some projects that have been on the back burner for a while. I have several series that I…

0