Best way to access a SQL Server database using C# .Net

I am new to .NET and have heard about several different ways of querying a SQL Server databse such as ADO.NET and the entity framework.

Can anyone give me some advise about the best way to go for new applications?

Thanks for any help or suggestions.