Excellent summary of what to use when. It would be great is someone would finish the chart that you started in the video for us.
Cloud Architect, Technical Project Manager and Developer specializing in architecting, designing, implementing and supporting application systems and computing infrastructures based on Cloud Technologies. My specialization is in Microsoft technology based public and private Clouds, including Microsoft Azure.
odujosh is absolitely correct. The main advantage of LINQ to Datasets is if you have a lot of them because your applications already depend on them heavily.