Ability to set an Include List

[GoogleCodeExporter]

I had a specific  requirement to just create classes for 6-10 tables out 
of a database of 200 + tables

It would be nice if we had a TableSchemaCollection allow either include 
tables or to exclude specific tables rather than to create all and then 
edit the ones you don't need 

Have I missed a setting that does that ?

Mike

Original issue reported on code.google.com by mike.one...@za.sabmiller.com on 16 Sep 2009 at 10:55

[GoogleCodeExporter]

What framework are you asking about?

Original comment by shannon....@gmail.com on 18 Sep 2009 at 4:39

[GoogleCodeExporter]

Original comment by shannon....@gmail.com on 18 Sep 2009 at 4:39

• Changed state: AwaitingInfo

[GoogleCodeExporter]

Sorry I am using Plinqo , most recent templates

Original comment by mike.one...@za.sabmiller.com on 21 Sep 2009 at 11:51

[GoogleCodeExporter]

I am in exactly the same boat with my current project.
We are building a custom solution on top of proprietary CMS system.

To generate the Data Access Layer just for our custom tables I have added them 
to a custom schema, while leaving all CMS table in default dbo schema.

Then on "IgnoreList" property I added this regex  "^(dbo\.).+" thus filtering 
out all 
dbo.* tables. 

The problem though is that if I do need to generate code for one or more CMS 
tables, I'd 
be in trouble. Managing this using regex is difficult. A much preferred option 
is to pick 
tables you want using table picker dialog. I think I saw the request for this 
feature.

Original comment by oleg.put...@gmail.com on 27 Sep 2009 at 6:36

[GoogleCodeExporter]

We understand the issue here.  There are issues with lists as well as regexes.  
We will 
consider adding this feature to the templates.

Original comment by shannon....@gmail.com on 2 Oct 2009 at 4:18

• Changed state: UnderConsideration
• Added labels: Framework-PLINQO, Type-Enhancement

[GoogleCodeExporter]

Original comment by shannon....@gmail.com on 2 Oct 2009 at 7:49

• Changed title: Ability to set an Include List

[GoogleCodeExporter]

I agree. that this is a much needed feature.

I would prefer a list with a checkbox  

I would also extend this request to include sprocs views and UDF's

Original comment by steveatc...@gmail.com on 20 Oct 2009 at 2:46

[GoogleCodeExporter]

Hi 

any thoughts on this , I have been evaluating the huagati tool that allows sync 
with 
the db and the dbml , with table selection included , its quite comprehensive , 
but 
only does the db- dbml sync, but I would rather stay with the Plinqo approach 
for a 
variety of reasons , mosttly the other features such as managers

I have looked at the published plinqo source code , but to try to adjust it do 
this 
would be complex not fully understanding the knock on effects.

I think there would be a general vote for this feature as on many occasions you 
may 
wish to model a part of the db , or simply to exclude the odd table

Mike

Original comment by mike.one...@za.sabmiller.com on 29 Oct 2009 at 8:16

[GoogleCodeExporter]

Would't it be easier to add a "simple" regex editor and leave the current
implementation as is?

You add an editor that allows you to either select "add all tables except" or
"exclude all tables except" and a list of tables with checkboxes. You generate 
the
regex accordingly.

Original comment by b.cl...@gmx.net on 23 Nov 2009 at 4:04

[GoogleCodeExporter]

Hi 

Has this one just died a death ?

Cheers Mike

Original comment by mike.one...@za.sabmiller.com on 14 Apr 2010 at 6:23

[GoogleCodeExporter]

Mike,

This is not dead.  We are just trying to juggle priorities. :-)  I know that 
doesn't
help, but hopefully you can understand.

Original comment by e...@ericjsmith.com on 14 Apr 2010 at 3:39

[GoogleCodeExporter]

No Problem , I just returned to it an wondered where it was 

Mike

Original comment by mike.one...@za.sabmiller.com on 15 Apr 2010 at 5:31

[GoogleCodeExporter]

This is a must feature. I can't exclude manually 220 of my 280 tables from the
database! Please rush!

Original comment by alonec...@gmail.com on 3 May 2010 at 5:40

[GoogleCodeExporter]

I agree, I just moved onto a project with Sql Server versioning turned on and 
we have
to exclude those sprocs and tables, then we have an entire schema that needs to 
be
excluded , Also, there are another handfull of views UDFs and tables that need 
to be
excluded. The regex is prone to errors and fat fingering and starting to become 
a
liability  

Original comment by steveatc...@gmail.com on 3 May 2010 at 5:53

[GoogleCodeExporter]

Hello,

We are currently looking into what it would take to implement this feature. In 
the mean 
time I recommend taking a look at the following community post: 
http://community.codesmithtools.com/forums/p/10167/39054.aspx

Thanks
-Blake Niemyjski

Original comment by bniemyjski on 4 May 2010 at 6:44

• Changed state: Investigating

[GoogleCodeExporter]

Hi Blake 

And a year has passed ? I hate to nag

I see you are heading off to do the EF Framework, imho before some of the 
basics os L2S are done.

I have given up trying to use Plinqo for db 's i don't own as inevitably I do 
not want to model all the tables . Surely a simple Include TableSchema 
Collection shouldn't too hard to do . I implement such things in other 
Codesmith templates with ease.

I use the competition (Huagati DBML tool) to select and sync my tables and then 
write templates to do the manager stuff and hence I lose out on the Caching , 
Rules etc goodies.

I see this as a 'need to have' if Plinqo is get any real traction , not all 
developers have command of their own db's 

I would love to use PLINQO Actively but this is stopping the show for me

Mike

Original comment by mike.one...@za.sabmiller.com on 5 Nov 2010 at 10:54

[GoogleCodeExporter]

I vote for this feature again.
It a minimum there should be an option to chose between exclusion and inclusion 
lists, but table/view/proc/function picker would be the best.

Original comment by oleg.put...@gmail.com on 5 Nov 2010 at 10:53

[GoogleCodeExporter]

I have already implemented this on 11th June 2010 and sent it to the team, Not 
sure if they have applied yet or not. However attached is the patch.

You should have nothing in the ignorelist and add everything you want to 
include in the includelist i.e.:
<property name="IgnoreList">
        <stringList>
        </stringList>
      </property>
      <property name="IncludeList">
        <stringList>
          <string>^dbo.T_BtBoat$</string>
...        
        </stringList>
      </property>

Happy Codding!

Original comment by alonec...@gmail.com on 8 Nov 2010 at 9:12

Attachments:

• IncludeList.ByDotNetWise.Patch

[GoogleCodeExporter]

And the response from CodeSmith was deafening -- Sorry !!

Original comment by mike.one...@za.sabmiller.com on 25 Nov 2010 at 11:54

[GoogleCodeExporter]

Hey guys,

I'll bring this up at tomorrow mornings scrum meeting. It is never our 
intention to ignore anyone or any topic. We are really busy and sometimes 
things slip through the cracks. Support gets an email alert anytime something 
is changed and I'll look into our processes to figure out if their is a better 
way each team member in charge of a specific framework can take action sooner. 

Please keep in mind that we do have to manage our resources as a company. With 
this said your feedback is very important and bringing this to our attention is 
greatly appreciated. It really does help us delegate our resources. In the 
future if you don't get a response within 2-3 business days from leaving a 
Google code issue response, please email me directly at 
bniemyjski@codesmithtools.com and I'll make sure an action is taken ASAP! We 
try and respond within one business day!

So a little history on this issue. We did design and demo an interface for 
excluding or including tables some time ago but we never completely came to a 
conclusion if we needed additional work or to address this differently.

I'll talk to the team in the morning and see if we can get a permanent solution 
included in a nightly. I personally find it odd that we need an include and 
exclude list... I can't confirm anything but we may be changing the way a 
plinqo project is configured completely ;).

Thanks
-Blake Niemyjski

Original comment by bniemyjski on 29 Nov 2010 at 7:37

[GoogleCodeExporter]

Hello,

Upon our discussion this morning. This functionality is available in the latest 
version or nightly build. Their is both an include and an exclude list that can 
be configured in the dbml output.

Please let us know if you have any questions.

Thanks
-Blake Niemyjski

Original comment by bniemyjski on 29 Nov 2010 at 6:50

• Changed state: Fixed