Hi Francisco ,  Thanks for your reply.

Yes that more or less works I was able to get the Column name and Type.

The problem that I'm still having is for column of type Int? for example  Nullable types  they return   System.Nullable`1[T]

when  executing  prop.PropertyType.Name

The reason I am trying to get these types is I'm trying to dynamically loop through all columns so to get their value  example a foreach statement.

But I believe I need to know the data Type before I call the Getitem so that I can use the case or switch command to control my Getitem method <int> or <string> for example,  unless their is a another way  of doing this which I do not know about

Various ways to call the Getitems

from the IDatastoreBase 

  public TValue GetItem<TValue>(int row, string column, DwBuffer bufferType = DwBuffer.Primary, bool isOriginalValue = false);

  public TValue GetItem<TValue>(int row, short column, DwBuffer bufferType = DwBuffer.Primary, bool isOriginalValue = false);

From the IDataStore<T>

TValue GetItem<TValue>(int row, Func<TModel, TValue> columnSelector, DwBuffer bufferType = DwBuffer.Primary, bool isOriginalValue = false);

can the columnSelector be a numeric value example index of the model.

Thanks Daniel

Hi Daniel,

Is there a particular reason you to retrieve the columns' names and types?
A C#-native way to do this would be using the nameof and typeof operators on the model.

For example:

var props = typeof(Model).GetProperties();
foreach (var prop in props) 
{
    var name = prop.Name;
    var type = prop.PropertyType.Name;
}

Let me know if this helps.

Regards,
Francisco