-21 。
正如您所看到的,数据库链接还包括了 Name 、 Provider 等属 性,它们都用于以后数据库的连接。
ltConnectionsgt ltConnection AppSettingsObjectNamequotWeb.configquot AppSettingsPropertyNamequotDatabaseConnectionStringquot ConnectionStringObjectquotquot IsAppSettingsPropertyquotTruequot ModifierquotAssemblyquot NamequotDatabaseConnectionString Web.configquot ParameterPrefixquotquot PropertyReferencequotAppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.DatabaseConnectionString.ConnectionStringquot ProviderquotSystem.Data.SqlClientquotgt lt/Connectiongt lt/Connectionsgt 代码 2-21 Database.xsd 代码片段( 1 )2 、数据的执行用 XXXCommand 表示这里是偶的解释,可以跳过 在前面的 SQL 语句向导里,由于要求系统根据 Select 语句自动生成 Delete 、 Update 和Insert 语句以及方法,所以系统将使用 ltSelectCommandgt 、 ltDeleteCommandgt 、ltUpdateCommandgt 和 ltInsertCommandgt 来表示这些方法,并建立这些方法所需要的参数,如2-22 。
ltDbSource ConnectionRefquotDatabaseConnectionString Web.configquot DbObjectNamequotdbo.Productsquot DbObjectTypequotTablequot FillMethodModifierquotPublicquot FillMethodNamequotFillquot GenerateMethodsquotBothquot GenerateShortCommandsquotTruequot GeneratorGetMethodNamequotGetAllProductsquot GeneratorSourceNamequotFillquot GetMethodModifierquotPublicquot GetMethodNamequotGetAllProductsquot QueryTypequotRowsetquot ScalarCallRetvalquotSystem.Object mscorlib Version2.0.0.0 CultureneutralPublicKeyTokenb77a5c561934e089quot UseOptimisticConcurrencyquotFalsequot UserGetMethodNamequotGetAllProductsquot UserSourceNamequotFillquotgt ltDeleteCommandgt ltDbCommand CommandTypequotTextquot ModifiedByUserquotFalsequotgt ltCommandTextgtDELETE FROM Products WHERE ProductID Original_ProductIDlt/CommandTextgt ltParametersgt ltParameter AllowDbNullquotFalsequot AutogeneratedNamequotquot DataSourceNamequotquotDbTypequotInt32quot DirectionquotInputquot ParameterNamequotOriginal_ProductIDquot Precisionquot0quotProviderTypequotIntquot Scalequot0quot Sizequot0quot SourceColumnquotProductIDquotSourceColumnNullMappingquotFalsequot SourceVersionquotOriginalquotgt lt/Parametergt lt/Parametersgt lt/DbCommandgt lt/DeleteCommandgt ltInsertCommandgt ltDbCommand CommandTypequotTextquot ModifiedByUserquotFalsequotgt ltCommandTextgtINSERT INTO Products ProductName CategoryID PriceInStore Description VALUES ProductName CategoryID Price InStoreDescriptionlt/CommandTextgt ltParametersgt ltParameter AllowDbNullquotTruequot AutogeneratedNamequotquot DataSourceNamequotquotDbTypequotStringquot DirectionquotInputquot ParameterNamequotProductNamequot Precisionquot0quot.