Pablo Castro, the Program Manager of the ADO.NET team, posted some great code samples from his PDC presentation
. There are a variety of demos available. The one I spent the most time playing with was the one that used BCP on the client to bulk insert back to the server. If you need to move large amounts of data from the client to the server it's definitely worth a look.