PatShop4.0学习笔记：连接字符串

?ConnectionString="<%$ ConnectionStrings:SQLConnString %>"

?

ConfigurationManager.ConnectionStrings["SQLConnString"].ConnectionString;

?

在项目的类中使用ConfigurationManager，除了添加 using System.Configuration;，还要在类的右击“引用”，添加System.Configuration。

?

?<caching>
???<sqlCacheDependency enabled="true" pollTime="10000">
????<databases>
?????<add name="MSPetShop4" connectionStringName="SQLConnString1" pollTime="10000"/>
????</databases>
???</sqlCacheDependency>
??</caching>

<appSettings> ??<!-- Pet Shop DAL configuration settings. Possible values: PetShop.SQLServerDAL for SqlServer,PetShop.OracleServerDALfor Oracle. --> ??<add key="WebDAL" value="PetShop.SQLServerDAL"/> ??<add key="OrdersDAL" value="PetShop.SQLServerDAL"/> ??<add key="ProfileDAL" value="PetShop.SQLProfileDAL"/> ??<!-- Enable data caching --> ??<add key="EnableCaching" value="true"/> ??<!-- Cache duration (in hours-whole number only) --> ??<add key="CategoryCacheDuration" value="12"/> ??<add key="ProductCacheDuration" value="12"/> ??<add key="ItemCacheDuration" value="12"/> ??<!-- Cache dependency options. Possible values: PetShop.TableCacheDependency for SQL Server and keep empty for ORACLE --> ??<add key="CacheDependencyAssembly" value="PetShop.TableCacheDependency"/> ??<!-- CacheDatabaseName should match the name under caching section,when using TableCacheDependency --> ??<add key="CacheDatabaseName" value="MSPetShop4"/> ??<!-- *TableDependency lists table dependency for each instance separated by comma --> ??<add key="CategoryTableDependency" value="Category"/> ??<add key="ProductTableDependency" value="Product,Category"/> ??<add key="ItemTableDependency" value="Product,Category,Item"/> ??<!-- Order processing options (Asynch/Synch) --> ??<add key="OrderStrategyAssembly" value="PetShop.BLL"/> ??<add key="OrderStrategyClass" value="PetShop.BLL.OrderSynchronous"/> ??<!-- Asynchronous Order options --> ??<add key="OrderMessaging" value="PetShop.MSMQMessaging"/> ??<add key="OrderQueuePath" value="FormatName:DIRECT=OS:MachineNamePrivate$PSOrders"/> ??<!-- Application Error Log --> ??<add key="Event Log Source" value=".NET Pet Shop 4.0"/> ?</appSettings>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!