using code to set nettiers' default dataprovider dynamically

            DSP.MIS.Data.SqlClient.SqlNetTiersProvider p = new DSP.MIS.Data.SqlClient.SqlNetTiersProvider();

            System.Collections.Specialized.NameValueCollection collection = new System.Collections.Specialized.NameValueCollection();

            collection.Add("UseStoredProcedure", "false");

            collection.Add("EnableEntityTracking", "true");

            //collection.Add("EntityCreationalFactoryType", "Northwind.Entities.EntityFactory");//I think this is not an correctly code, so I remark it ,it seems okay after be remarked, noted by zy 2012-5-18

            //when I was writing the date '5-12', I remembering  the 2008 Wenchuan earthquake,expressed regret over the decedents

            collection.Add("EnableMethodAuthorization", "false");

            collection.Add("ConnectionString", "packet size=4096;user id=sa;data source=127.0.0.1;persist security info=True;initial catalog=Schuldatenbank-Local;password=Abcd1234");

            collection.Add("ConnectionStringName", "GermanSchool.My.MySettings.netTiersConnectionString");

            collection.Add("ProviderInvariantName", "System.Data.SqlClient");

            p.Initialize("default", collection);

            DataRepository.LoadProvider(p, true);

            DataRepository.Provider.ExecuteScalar(CommandType.Text, "select count(1) from Parent").ToString(); // test the provider

 

 

悼念5.12地震中逝去的同胞