Ipaddress data type

Posts   
 
    
El Barto
User
Posts: 64
Joined: 09-Nov-2006
# Posted on: 19-Feb-2019 21:05:19   

I'm using LLBLGen 5.4 and I noticed an ipaddress type shortcut. I wanted to use it but I don't know what DB datatype I need to use. I've tried nvarchar and varbinary but it complains it needs a type converter. What database data type do I need to use or do I need to write a typeconverter?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 20-Feb-2019 06:37:56   

Hi there!

AFAIK, that System.Net.IPAddress is a .Net type, and that's why it's there, but there is no a DB type that matches it and no System TypeConverter that do the conversion automatically. So, if you want to use that type you have to implement a TypeConverter. It's not that hard, you could use the examples in the source code.

David Elizondo | LLBLGen Support Team
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 20-Feb-2019 09:23:05   

The type is a native type of PostgreSQL and its ado.net provider, hence it's present as a shortcut.

Frans Bouma | Lead developer LLBLGen Pro