Thanks, I found that to work too - but there are cases when it doesn't. I looked at the Mono (2.4) command builders and they derive from a base class which contains a reference to the data adapter, BUT, they declare a DUPLICATE data adapter reference in the derived class. So, when you use it through the base class, you get this error, because the base class is using its own reference (which is not initialised, because the initialised adapter reference is in the derived class).
Also, the hooks to catch the Update/Insert/Delete events are hooked to the derived class, and again, then working with the base class means that the commands are not performed when they should be. I "repaired" this by upgrading the base class and the derived classes in my own namespace - however this results in becoming "platform-specific", which is not ideal. I also ran into other issues with using ALIASED columns and columns that may contain NULLs, so, in the end, I gave up on the whole CommandBuilder (as advised by many, in any case). Still, this is a bug that should be fixed. Of course, I could be the silly-billy that missed something - so opinions are always welcome. YJ Foo wrote: > > MySqlDataAdapter adapter = Database.CreateDataAdapter(this.Conn, query); > MySqlCommandBuilder cb = new MySqlCommandBuilder(adapter); > > //This fixes the Mono InvalidOperation issue, but it crashes when run > under .Net > //InvalidOperation: Dynamic SQL generation is not supported against > multiple base tables. > adapter.UpdateCommand = cb.GetUpdateCommand(); > adapter.DeleteCommand = cb.GetDeleteCommand(); > adapter.InsertCommand = cb.GetInsertCommand(); > > ----------------------- > I hope this helps. I am running my application on a Windows XP system > though, so I am unsure if my fix will be work for you. > -- View this message in context: http://www.nabble.com/Auto-SQL-generation-during-Update-requires-a-valid-SelectCommand-tp22550410p23229052.html Sent from the Mono - ASP.NET mailing list archive at Nabble.com. _______________________________________________ Mono-aspnet-list mailing list [email protected] http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
