| 5/3/2006 3:08:50 PM |
Hi Paul,
I noticed there's no SQL2005 choice in the WilsonORHelper. Furthermore I get an error (without message) when trying to connect to it. Is support for SQL express planned any time soon? (I tried the following connect string, which works in a code prototype I worked out: "Data Source=GDV842J\SQLEXPRESS;Initial Catalog=FingerPrint;Integrated Security=True").
Kind regards,
Wout
E-mail: wout at woutware dot com
|
| 5/3/2006 3:36:17 PM |
Hi Wout:
As least with the full Sql Server 2005 product there is no need for anything special in the ORHelper -- just select Ms Sql. The Sql2005 Provider in the ORMapper is necessary to get paging optimized using the Row_Number function, and maybe other Sql 2005 specific things in the future, but the ORHelper just gets the schema and nothing more. As for SqlExpress, I know it works with the ORMapper pretty easily, but I haven't tried it with the ORHelper -- have you tried something like "Server=GDV842J\SQLEXPRESS;DataBase=FingerPrint;Integrated Security=SSPI;"?
Thanks, Paul Wilson
|
| 5/5/2006 12:47:28 AM |
Hi Paul,
Yep, that connection string works better, now the tool works.
Only it doesn't detect nullable columns yet, but it's already very useful!
Thanks,
Wout
|