It seems like I made some really stupid mistake somewhere following chapter 2, insert method.
Everything compiles OK but got an error from db.SubmitChanges();
[FONT='Times New Roman','serif']An attempt to attach an auto-named database for file C:\Users….Data_for_VS2008\HRPaidTimeOff.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.[/FONT]
Any Idea?

Is your database where the connection string says it is? (C:\Users….Data_for_VS2008\HRPaidTimeOff.mdf)

Where in the code did you get the error?

This thing drives me nuts.
I already deleted everything, started over, and got same error message.
I am using SQL Express 2008 with Vista Home.
My connection string in app.config HRTimePaidOffDAL looks like:
<connectionStrings>
<addname="V2.PaidTimeOffDAL.Properties.Settings.HRPaidTimeOf fConnectionString"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\...\ HRPaidTimeOff.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
and pointed to the right location.
I tried to play around with security and User Instance – still getting same error message …

And there is only Insert button click event in the code:

protectedvoid btnInsert_Click(object sender, EventArgs e)
{
HRPaidTimeOffDataContext db = newHRPaidTimeOffDataContext();
ENTUserAccount userAccount = newENTUserAccount
{
WindowsAccountName = @"VARALLO1\VaralloMadison",
FirstName = "Madison",
LastName = "Varallo",
Email = "[email protected]",
IsActive = true,
InsertDate = DateTime.Now,
InsertENTUserAccountId = 1,
UpdateDate = DateTime.Now,
UpdateENTUserAccountId = 1
};
db.ENTUserAccounts.InsertOnSubmit(userAccount);
db.SubmitChanges();
}

Finally made it work. But it works only if I put my data base into web site's App_Data folder ...