I am trying to use the DAL2 in a module and having some issues with selecting things from the database.  When I use a SQL Profiler to look at the SQL that makes it to the database I am seeing queries that do not specify the field names to select.  The statement is starting off "SELECT NULL".  Here is a more complete view of what I see:

exec sp_executesql N'SELECT NULL FROM [Product] WHERE [productCode]=@0',N'@0 nvarchar(4000)',@0=N'ANDY' 

The SQL above was produced by the GetById() function of the IRepository. Here is the code:

public Product GetItem(string key)
        {
            Product t;
            using (IDataContext ctx = DataContext.Instance(EXTERNAL_DB_CONNECTION_STRING))
            {
                var rep = ctx.GetRepository<Product>();
                t = rep.GetById(key);
            }
            return t;
        }

The field names in my class file all match the database field names.  I have specified the TableName(), PrimaryKey(), and Cacheable() in my class file.

What needs to be done so the fields will be selected?

I discovered the problem is related to the field definitions in the object file.  To make DAL2 discover the fields and use them in queries, the fields need get and set accessors.

 public string productCode; //This will not be mapped to the database field using DAL2

public string productCode { get; set; }// This will be mapped to the database field using DAL2

If anyone has additional information about why this is a requirement, or a link to documentation showing that this is a requirement, please add it to this thread.

Good luck and happy coding!