Translating a SQL call from AutoIt to C#

[JLogan3o13]

This is just a curiosity question; I've been playing with C# a little bit, with VS 2010 Express. I've taken a front-end I wrote in AutoIt, and am working through converting functions just to see what the translation looks like. One thing I have run into hurdles with is making a connection to and sending calls to a SQL database. I've been googling a bit, just thought I would ask here as well as I know many forum members work in other languages. Below is a snipped of the function in AutoIt, if anyone can nudge me in the right direction I would appreciate it.

Connection

$oLocator = ObjCreate("WbemScripting.SWbemLocator")
$oSMS = $oLocator.ConnectServer($sServer, "root\sms\site_" & $SCode)
   If @error Then Exit MsgBox(0, "Sparrow SCCM Console", "Can't Connect")
$oSMS.Security_.ImpersonationLevel = 3
$oSMS.Security_.AuthenticationLevel = 6

Sample Call

$oResults = $oSMS.ExecQuery("SELECT * FROM SMS_Collection WHERE Comment LIKE '%License%' ORDER by Name")

Edited January 7, 2013 by JLogan3o13

[cageman]

just a google search gave me this:

http://msdn.microsoft.com/en-us/library/windows/desktop/aa393720%28v=vs.85%29.aspx

[danielkza]

You should also check LINQ to SQL.