[Mono-aspnet-list] Auto SQL generation during Update requires a valid SelectCommand

YJ Foo yujyefoo at gmail.com
Fri Apr 24 15:08:30 EDT 2009

MySqlDataAdapter adapter = Database.CreateDataAdapter(this.Conn, query);
MySqlCommandBuilder cb = new MySqlCommandBuilder(adapter);

//This fixes the Mono InvalidOperation issue, but it crashes when run under
//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-tp22550410p23222999.html
Sent from the Mono - ASP.NET mailing list archive at Nabble.com.

More information about the Mono-aspnet-list mailing list