Hi,

1.
We are using the OleDbConnection provider object and the following meta-data can be read from it:

{ColumnName}
{ColumnOrdinal}
{ColumnSize}
{NumericPrecision}
{NumericScale}
{DataType}
{ProviderType}
{IsLong}
{AllowDBNull}
{IsReadOnly}
{IsRowVersion}
{IsUnique}
{IsKey}
{IsAutoIncrement}
{BaseSchemaName}
{BaseCatalogName}
{BaseTableName}
{BaseColumnName}

There is no default value that can be retrieved. If you are aware of any libray that gets the default values we can evaluate it and try to use it.

2. Regarding the properties sort order: We created the options dialog that you can use to apply the sort you want. It is also possible to set the logging for the NConstruct Builder application if needed. See figures below.







The new NConstruct version 2.5.1 will be available tomorrow.

Regards,
Pistotnik S.
_______________________

NConstruct Support Team
support@nconstruct.com
http://www.nconstruct.com
_______________________

Thanks a lot for your improvement !

it will be very usefull to me.

...

For getting default values, maybe this code helps you (sorry it's vb.net) :


Imports System.Data.OleDb

Namespace utils
Public Module Module1

Function get_defaults_for_table(ByVal connection_string As String, ByVal table_name As String) As String

Dim mySqlConnection As OleDbConnection
Dim s As String = ""

Dim restrictions As String() = New String(3) {Nothing, Nothing, table_name, Nothing}
mySqlConnection = New OleDbConnection(connection_string)
mySqlConnection.Open()

'Dim o As System.Data.DataTable = mySqlConnection.GetSchema("Columns", restrictions) 'also works
Dim o As System.Data.DataTable = mySqlConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, restrictions)
Dim c As System.Data.DataRow

For Each c In o.Rows
If c.Item("COLUMN_HASDEFAULT") = True Then
s = s & (c.Item("COLUMN_NAME") + " default value is " + c.Item("COLUMN_DEFAULT").ToString) + "/"
End If
Next

mySqlConnection.Close()

Return s
End Function

End Module
End Namespace


Making this call

Console.WriteLine(Module1.get_defaults_for_table("Provider=sqloledb;Data Source=SD200001;Initial Catalog=Northwind;Integrated Security=SSPI;", "Products"))


i got this

UnitPrice default value is ((0))/UnitsInStock default value is ((0))/UnitsOnOrder default value is ((0))/ReorderLevel default value is ((0))/Discontinued default value is ((0))/


I have tested it in sql server, maybe it works in oracle too.