Archived Thread: 'includeTableList option not working?'

• includeTableList option not working?

  Posted by jihohan on Tuesday, June 26, 2007

  I'm trying to limit the number of tables being generated because I have 400+ tables and I only need like 4.  So I'm trying to use includeTableList and sonic.exe seems to be ignoring it for some reason (meaning it generates for 400 tables).  I have the following in my app.config - seems to have the same problem when i put it on the command line -:

  <add name="Infinity_Dev"

  type="SubSonic.SqlDataProvider, SubSonic" connectionStringName="Infinity_Dev"

  generatedNamespace="Infinity"

  includeTableList="ACCOUNT,USERINFO"/>

  Any idea what I might be doing wrong?

  [UPDATE] I got it to work - Apparently, the value for includeTableList is a regex?  I remember reading somewhere (perhaps the usage from sonic.exe) the value's supposed to be a comma-delimited list of table names.  a little confused.

• Re: includeTableList option not working?

  Posted by canofunk on Tuesday, June 26, 2007

  Yup... it's regex. If you want to perform and exact match on table names, use regex word boundaries:

   

  \bACCOUNT\b 

• Re: includeTableList option not working?

  Posted by swaino on Tuesday, April 29, 2008

   Can you provide any examples?  Why can't it just pick up the list of tables in the ABP file?

• Re: includeTableList option not working?

  Posted by madkidd on Tuesday, April 29, 2008

  I tried this and it still did not work:

  sonic generatetables /out code /includeTableList \bDownloadCode\b

• Re: includeTableList option not working?

  Posted by madkidd on Tuesday, April 29, 2008

  Added the following to my App.config instead of trying to do it through the command line and it worked:

  includeTableList="\b(DownloadCode|Record)\b"