Database-backed Caching in the Enterprise Library: missing stored procedure?
I am trying to get the Caching application block from “Microsoft Enterprise Library January 2006” to work with SQLExpress as the backing store.I’ve run the supplied config script that sets up the database with the appropriate tables and stored procedures.
When I try to create a CacheManager, method Microsoft.Practices.EnterpriseLibrary.Data.Database.DoLoadDataSet throws an exception while trying to execute the stored procedure “LoadItems”. I expect that this is because there is no such stored procedure. A check of the config script, "SqlConfiguration.sql", shows that it did not attempt to create one.
The stored procedures that are created by SqlConfiguration.sql are:
- EntLib_GetConfig
- EntLib_RemoveSection
- EntLib_SetConfig
- UpdateSectionDate
Has “LoadItems” morphed into “EntLib_GetConfig”?Or am I totally barking up the wrong tree? Has anyone got this to work? In App.config, what should I specify in the "partionName"?
Thanks.
