RE: Decrypting web.config file on different machine

2012-01-19 Thread Greg Keogh
Can someone confirm that ASP.NET config files are usually encrypted with the machine key? Is that the only option? (something about /Machine DPAPI). If so, then your only hope is to send the file to the NSA or Dr Who for recovery -- Greg -Original Message- From:

Re: [OT] t-sql, dealing with null

2012-01-19 Thread Wallace Turner
thanks for that detailed response, very interesting. for the record the SP was not that short, it was something more complex buried deep within the stored proc. Isnull + coalesce in queries when you have to, but I try to write only positive queries, or queries against non null fields. Good

Re: [OT] t-sql, dealing with null

2012-01-19 Thread David Rhys Jones
Oh and I forgot, you can write positive queries for negative results. ie select * from address where city 'New York' -- Never use this form. consider * 1. select * from address where not addressId in (select addressId from address where city = 'New York')* *2. select * from address

Re: EF4 and SQLite - more clues

2012-01-19 Thread David Burela
Which version of EF are you using? 4.0, 4.1, 4.2? Did you install the latest version via NuGet? Did you make sure that all the EF references are set to copy local = true? On 19 January 2012 00:19, Greg Keogh g...@mira.net wrote: I took the bother of writing a simple test harness app that read

RE: EF4 and SQLite - more clues

2012-01-19 Thread Greg Keogh
Which version of EF are you using? 4.0, 4.1, 4.2? Did you install the latest version via NuGet? Did you make sure that all the EF references are set to copy local = true? 4.0 (they're up to 4.2 now?!) No, I don't know what NuGet has to do with EF4 and SQLite, I thought it was a plugin

Re: Decrypting web.config file on different machine

2012-01-19 Thread Bec Carter
Damn :( plus no source code which means Reflector and Dr Who. I should have stayed away from the govt, they have no source but they have Reflector vspro.. go figure On Thu, Jan 19, 2012 at 9:45 PM, Greg Keogh g...@mira.net wrote: Can someone confirm that ASP.NET config files are usually