David,
> I am getting the following error : "Dynamic SQL generation is not supported against multiple base tables" when I try to update my SQL Database from my DataSet (which uses a SELECT Statement containing a JOIN).
>
>Does anyone have an easy way around this in Mere Mortals? Will I need to use Stored Procedures?
>
>Any replies are appreciated.
The most straightforward way is to used stored procedures. ADO.NET is not especially tuned for updating multiple back end tables from a single DataTable.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com