If you are using SP 2010, You can access SP Lists by using SPMetal.
Though SPMetal ignores few fields like Modified, Created etc. You can include these fields using an XML file consisting of parameters.