How to get DataTable (don't know fields)

Posts   
 
    
swegele
User
Posts: 33
Joined: 25-Jan-2007
# Posted on: 21-Feb-2007 00:34:53   

Our application has a feature where Customer can add their own fields to "Extension" tables. These "Extensions" are exposed on an object as a property of type DataTable.

I cannot know what is in there so I can't create fields for projection or whatever.

Can I use LLBLGen to run a SQL query and return a datatable...or do I have to use my own DAL for fetching, updating datatables?

So basically I need to be able to Select * From CustomerEXT Where Id = ? Get the datatable...then be able to update it later if they made changes

Pretty simple...but I just didn't know if I could reuse LLBLGen DB code

Sean

bclubb
User
Posts: 934
Joined: 12-Feb-2004
# Posted on: 21-Feb-2007 01:50:57   

I don't think you can do this with LLBLGen without some work. This thread was started a couple of months ago that is along the same lines and may shed some light as to whether you could do this or not.

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=8232&HighLight=1