C# database programming book recommendation

I'd consider myself quite an experienced C# WinForms application developer. But I'm looking to teach myself database programming with C# and SQL Server. I've been trying to find a decent book that covers this but I've had no luck at all. The books I've found so far and the issues with them are:

Mastering C# Database Programming
https://www.amazon.co.uk/Mastering-Database-Programming-Jason-Price/dp/0782141838/ref=sr_1_1?s=books&ie=UTF8&qid=1286042794&sr=1-1
This book seems ideal but is far too out of date. It uses SQL Server 2000 and Visual Studio .NET.

Beginning C# 2008 Databases: From Novice to Professional
https://www.amazon.co.uk/Beginning-2008-Databases-Professional-Professionals/dp/1590599004/ref=sr_1_3?s=books&ie=UTF8&qid=1286042794&sr=1-3
This seems to be ideal but the Amazon review comments put me off as they say the book covers basics for C# and the basics for Databases but not how to can be used together to program.

I've exhausted all the keyword searches I can think of and can't find a single book that will meet my needs but I'm sure there must be something out there.

My requirements for the book are:
1. Must use Microsoft SQL Server 2005 or later as the primary database technology.
2. Must use C# and Visual Studio 2005 or later as the primary programming technology.
3. Must cover TSQL, SQLXML, stored procedures and triggers.

Any recommendation will be gratefully appreciated.

TIA

Comments

Sign In or Register to comment.