Great news – SQLServer 2000 is now supported in DbFit. The only limitation, compared to Sql Server 2005, is that tables and procedures must be fully qualified (defined as schema.name), if there is an object of the same name in the current user’s schema and in dbo. The next official release will include sql server support — until then, you can download the binaries from Sourceforge: dbfit-dotnet-20080107.zip
the complete package, with acceptance tests, can also be downloaded from here: dbfit-complete-20080107.zip
For sqlserver 2000, use dbfit.SqlServer2000Test instead of dbfit.SqlServerTest.
Many thanks to Oscar Centeno for his help on implementing and testing support for Sql Server
|
|
dbfit 0.93 and 2008-01-07 code do not accept fully qualified(prefixed by schema name) [table|procedure|function} names when used with MS SQL 2005. Throws an exception System.ApplicationException: Cannpt read columns/parameters for object when calling
!|Execute Procedure|dbo.udf_ConcatenateString|
Works fine with:
!|Execute Procedure|udf_ConcatenateString|
SQL 2005 best practice is for use of schema prefix rather than the default schema
Hi Tom,
thanks for this – I’ve fixed the problem, you can download the build from Sourceforge. It will be included in the next regular release.