SubSonic column named 'Key'

Question

Hi!

I have a column named 'Key' in a MySQL database. Seems that the

repo.Find<Class>(x=>x.Key.StartsWith("BLAH")); 

generates the SQL code

WHERE Key LIKE 'BLAH%'

instead of the correct one like

WHERE `Key` LIKE 'BLAH%'

How can I force the later behaviour (is it a bug in SubSonic?)

Cheers, Tomasz

Answer 1

You can use the latest source from git - this is a bug that was resolved since releasing 3.0.0.4