How can I connect to a SQL Server in a console application in VC# express.

I'm trying to access a SQL Server to connect to databases in SQL Server to list, edit and delete records from a table.

Does any one know how to do this.

Joe