Error selecting from Sql 2005 when columns have spaces in the name

I did not create these fields, the database is close to 20 years old so please don't flame me. :)

I have a database that has spaces in the column names and this is part of the select statement that is passed

  Titles.Low Sheet,
  Titles.Reg Price,
  Titles.Sale Price,

This is what sql returns :)

Msg 207, Level 16, State 1, Line 41
Invalid column name 'Low'.

Msg 207, Level 16, State 1, Line 60
Invalid column name 'Reg'.

Msg 207, Level 16, State 1, Line 66
Invalid column name 'Sale'.

This is what the c# looks like

[Column("Low Sheet")]
private decimal _lowSheet;

[Column("Reg Price")]
private decimal _regPrice;

[Column("Sale Price")]
private decimal _salePrice;

This is what the entity property looks like:

<entityProperty name="RegPrice" dataType="Decimal" columnName="Reg Price" />

Am I doing something wrong or is there a setting I should make?

I am using the may 30 build.

Thanks,

Joe

Try setting LightSpeedContext.QuoteIdentifiers = true -- that should improve matters.  Let us know if it still doesn't work (and in this case could you attach the generated SQL?  Thanks!).

This is why I use your product. The support is amazing and if I RTFM, I would have found that.

It works, thanks ivan.

Joe