LINQ enabled Personal Web Site Starter kit

COMMENTED ISSUE: A database with the same name exists, or specified file cannot be opened, or it is located on UNC share

MadDog — Sun, 01 Jun 2008 20:11:41 GMT

Over and over - on lots of different machines
Comments: Same problem here. I just unpacked it, set customErrors=Off, and I get this message in debug mode. Still trying to figure it out.

CREATED ISSUE: A database with the same name exists, or specified file cannot be opened, or it is located on UNC share

mike_135 — Tue, 01 Apr 2008 23:57:38 GMT

Over and over - on lots of different machines

UPDATED RELEASE: PersonalWebLinqSharp (Mar 09, 2008)

Mon, 10 Mar 2008 01:13:18 GMT

C# port of the LINQ enabled Personal web starter kit ported by Steven Murray.

CREATED RELEASE: LINQ Enabled Personal Web in C sharp (Mar 09, 2008)

Mon, 10 Mar 2008 01:10:56 GMT

C# port of the LINQ enabled Personal web starter kit ported by Steven Murray.

UPDATED RELEASE: PersonalWebLinq (Feb 10, 2008)

Sun, 09 Mar 2008 22:24:38 GMT

Source code for LINQ enabled personal web site. Follow the instructions in the readme file to create the security users. Also, you will need to create the personal database and run the personal-add.sql in the app_data folder to set the database up. The LINQ changes can be found in the app_code/PhotoManager.vb file. The original ADO version is commented out and the LINQ version follows each method.

UPDATED RELEASE: PersonalWebLinqSharp (Mar 09, 2008)

Sun, 09 Mar 2008 22:24:10 GMT

C# port of the LINQ enabled Personal web starter kit ported by Steven Murray.

UPDATED RELEASE: PersonalWebLinq (Feb 10, 2008)

Mon, 18 Feb 2008 22:32:48 GMT

UPDATED WIKI: Home

jwooley — Sun, 10 Feb 2008 19:19:03 GMT

Resource Page Description
Rewrite of the original Personal Web Starter Kit using LINQ for the data tier rather than stored procedures and ADO. The starter kit manages images in a SQL database by album.

This project is a revision of the original Personal Web Starter Kit at http://www.asp.net/downloads/starter-kits/personal/ which was written as an introduction to Visual Studio 2005. This verision updates the original project to replace the ADO data access tier with one based on LINQ which was introduced with Visual Studio 2008. This sample demonstrates how to perform standard CRUD (Create, Read, Update, Delete) operations against a SQL Express or SQL Server database to manage a set of photo albums. For this update, the following changes were made:

Remove the Photo and Album business classes and replaced them with ones generated by the LINQ to SQL designer (in the Personal.dbml) file.
Removed the need for custom stored procedures for each of the CRUD operations.
Refactored the dynamic select statement selection repeated in the GetFirstPhoto and GetPhoto stored procedures into a single VB method which dynamically builds on the LINQ query using the composable nature of LINQ.
Applies randomizing logic for selecting a random Album by using a scalar function in the database.
Use LINQ to Objects to declaritivly add photos from the Update directory rather than using an iterative process (see Admin/Photos.aspx.vb)

UPDATED WIKI: Home

jwooley — Sun, 10 Feb 2008 19:14:05 GMT

Resource Page Description
Rewrite of the original Personal Web Starter Kit using LINQ for the data tier rather than stored procedures and ADO. The starter kit manages images in a SQL database by album.

This project is a revision of the original Personal Web Starter Kit which was written as an introduction to Visual Studio 2005. This verision updates the original project to replace the ADO data access tier with one based on LINQ which was introduced with Visual Studio 2008. This sample demonstrates how to perform standard CRUD (Create, Read, Update, Delete) operations against a SQL Express or SQL Server database to manage a set of photo albums. For this update, the following changes were made:

Remove the Photo and Album business classes and replaced them with ones generated by the LINQ to SQL designer (in the Personal.dbml) file.
Removed the need for custom stored procedures for each of the CRUD operations.
Refactored the dynamic select statement selection repeated in the GetFirstPhoto and GetPhoto stored procedures into a single VB method which dynamically builds on the LINQ query using the composable nature of LINQ.
Applies randomizing logic for selecting a random Album by using a scalar function in the database.
Use LINQ to Objects to declaritivly add photos from the Update directory rather than using an iterative process (see Admin/Photos.aspx.vb)

CREATED RELEASE: PersonalWebLinq (Feb 10, 2008)

Sun, 10 Feb 2008 18:58:39 GMT