In sqlite treat everything as strings and id columns as guid's. And it flys.
I tried tricking EF4 to think it was a string column. I've been trying for the last 2 hours to find out why the DateTime column returns nothing but a parse error when I try to access it. No matter if it contains nulls or valid data, no matter if it's nullable or not, no matter if I treat it as a string, no matter if I use reader.GetValues(object[]) to get the raw values. Nothing between heaven and hell can let me access the nullable datetime column to find what can't be parsed. If I treat everything as strings I'll have to manually convert everything that goes in and out of rows, then I might as well use a txt file for storage. I think my brief romance with SQLite is over and we're breaking up. Now I'm going to bed to cry myself to sleep. Greg
