An early Christmas present for you! On Tuesday we released version 2.0.0.8 of BDC Meta Man that has a new feature called the SQL Query Wizard (thanks to Ishai for pointing out how not to spell it like the rock band!). With the SQL Query wizard you can create methods for your entities that span multiple tables rather than having to create a view or stored procedure. We've tried to make the Query Wizard look and feel like the Query Designer in Access as most people have had to use that at some point.
Currently the Query Wizard only works for MS SQL Server but the next version will have Oracle and DB2 support. You can see a screen cast of the Query Wizard in action here:
http://www.bdcmetaman.com/Knowledge%20Base/sql-query-wizzard.aspx
We're keen to get your feedback on this new functionality so if you have any ideas, suggestions or pointer please do let me know at nick@lightningtools.com
Also in this release of BDC Meta Man it's possible to set the ShowInPicker property through the UI. This makes editing Business Data Columns much easier! Again we've got a screen cast available here:
http://www.bdcmetaman.com/Knowledge%20Base/showinpicker.aspx
You can get the new version of BDC Meta Man from the usual download place:
http://www.bdcmetaman.com/pages/download.aspx