Implimenting SQL in C#

We are doing a group project that requires access to a database with C#, but the google does nothing for helping us; how does I shot SQL commands in C#?  That is, how can I go about using SELECT * FROM DATABASE and such commands through .NET code?  We have all the software we need, but we don't know how to us it.