Accessing SQL data

Question

Hi everyone, I am a newbie to C-sharp. I have read couple articles to confuse myself with data access. I want to write an appropriate reusable logic to access SQL database. Is data provider the best way? can someone please guide? Thanks Vivek Sharma