Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Architecture> Postgres arrays
 

Pages: 1
Architecture
Postgres arrays
Page:1/1 

  Print all messages in this thread  
Poster Message
mihies
User



Location:
Nova Gorica, Slovenia
Joined on:
29-Jan-2006 16:00:15
Posted:
797 posts
# Posted on: 07-Oct-2017 21:12:24.  
Hi,

How would one deal with (database first) postgres column of integer[] type?
Designer happily sets its type as "string".
Miha Markic
MVP C#, LLBLGenPro Partner, DXSquad
Blog, Twitter
 
Top
mihies
User



Location:
Nova Gorica, Slovenia
Joined on:
29-Jan-2006 16:00:15
Posted:
797 posts
# Posted on: 08-Oct-2017 10:43:30.  
Ah, they are not supported according to docs. BTW using LLBLGenPro framework.
I wonder whether there is a workaround of some type.


Miha Markic
MVP C#, LLBLGenPro Partner, DXSquad
Blog, Twitter
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37186 posts
# Posted on: 09-Oct-2017 09:09:05.  
They're currently not supported indeed. One of the leftovers of v2 of npgsql, but also it's a bit of a complex thing to support (as every type can also form an array of that type).

At the moment I don't know of a workaround either, other than perhaps a typeconverter, but I think saving the data will be a problem (as it's likely, but haven't tested this, the type of the parameter isn't set properly when saving).

I've added a workitem to support these types in the future
Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
mihies
User



Location:
Nova Gorica, Slovenia
Joined on:
29-Jan-2006 16:00:15
Posted:
797 posts
# Posted on: 09-Oct-2017 09:32:38.  
That's what I thought.
Luckily, only a column is an array. I'll just convert that column to a string (with comma delimited values) and handle it with a typeconverter for the time being.
I'd be nice if arrays become first class citizens eventually. you have already something similar with byte[] types.


Miha Markic
MVP C#, LLBLGenPro Partner, DXSquad
Blog, Twitter
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37186 posts
# Posted on: 09-Oct-2017 10:06:19.  
mihies wrote:
That's what I thought.
Luckily, only a column is an array. I'll just convert that column to a string (with comma delimited values) and handle it with a typeconverter for the time being.
I'd be nice if arrays become first class citizens eventually. you have already something similar with byte[] types.

Yes, byte[] are a known type, but the rest is a large(r) set of types, so I have to think about either supporting int[], string[], short[] etc. vs. the root type (int, string, short) and a flag telling it's an array, for the typeshortcuts. But it'll likely be the former.

Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
mihies
User



Location:
Nova Gorica, Slovenia
Joined on:
29-Jan-2006 16:00:15
Posted:
797 posts
# Posted on: 09-Oct-2017 11:14:51.  
Arrays feel more natural so I vote for former Regular Smiley

Miha Markic
MVP C#, LLBLGenPro Partner, DXSquad
Blog, Twitter
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.