>>As long as I can make a connection to my SQL server, I can handle data using TSQL.

>>That's my story and I'm sticking to it.

You really can't go wrong with that approach. It's what Ive been using and I like it.
It does what I want the way I want it in a predictable way- just as it did with VFP.
I tried LINQ to SQL and it's quite simple, but it really gave me very little, so I want back to the TSQL method.
EF, however, seems to be a more completely developed and featured framework and if it sticks around a while it might entice me.