protected void createDatabaseButton_Click(object sender, EventArgs e)
        {
            string databasePath = Path.Combine(Server.MapPath(Request.ApplicationPath), "App_Data");
            if (!Directory.Exists(databasePath)) {
                Directory.CreateDirectory(databasePath);
            }
            string connectionString = ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString.Replace("|DataDirectory|", databasePath);
            var dc = new DataClassesDataContext(connectionString);
            if (dc.DatabaseExists()) {
                dc.DeleteDatabase();
            }
            try {
                dc.CreateDatabase();

                // Fill with sample data.
                dc.OAuthConsumers.InsertOnSubmit(new OAuthConsumer {
                    ConsumerKey = "sampleconsumer",
                    ConsumerSecret = "samplesecret",
                });
                dc.Users.InsertOnSubmit(new User {
                    OpenIDFriendlyIdentifier = "=arnott",
                    OpenIDClaimedIdentifier = "=!9B72.7DD1.50A9.5CCD",
                    Age = 27,
                    FullName = "Andrew Arnott",
                    FavoriteSites = new System.Data.Linq.EntitySet<FavoriteSite> {
                    new FavoriteSite { SiteUrl = "http://www.microsoft.com" },
                    new FavoriteSite { SiteUrl = "http://www.google.com" },
                },
                });

                dc.SubmitChanges();
                this.databaseStatus.Visible = true;
            } catch (System.Data.SqlClient.SqlException ex) {
                foreach (System.Data.SqlClient.SqlError error in ex.Errors) {
                    Response.Write(error.Message);
                }
            }
        }
示例#2
0
		private void Application_Error(object sender, EventArgs e) {
			Logger.Error("An unhandled exception occurred in ASP.NET processing: " + Server.GetLastError(), Server.GetLastError());

			// In the event of an unhandled exception, reverse any changes that were made to the database to avoid any partial database updates.
			var dataContext = dataContextSimple;
			if (dataContext != null) {
				dataContext.Transaction.Rollback();
				dataContext.Connection.Close();
				dataContext.Dispose();
				dataContextSimple = null;
			}
		}