Unable to run Chapter 2 Example

tkachuk · March 5th, 2009, 08:16 PM

I am reading this book via the Wrox 24/7 Books Online. I am using Visual Studio 2008 Professional and SQL Server 2008.

Following the examples in chapter 2 - Adding a Record section, when I run the application as instructed I get an error.

"Error 1 The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. C:\Users\x2ws\Documents\Visual Studio 2008\Projects\PaidTimeOffSolution\PaidTimeOffUI\De fault.aspx.cs 18 9 http://localhost/PaidTimeOffUI/"

"Error 2 The type 'System.Data.Linq.Table`1<T0>' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. C:\Users\x2ws\Documents\Visual Studio 2008\Projects\PaidTimeOffSolution\PaidTimeOffUI\De fault.aspx.cs 34 9 http://localhost/PaidTimeOffUI/"

"Error 3 'System.Data.Linq.Table`1<V2.PaidTimeOffDAL.ENTUse rAccount>' does not contain a definition for 'InsertOnSubmit' and no extension method 'InsertOnSubmit' accepting a first argument of type 'System.Data.Linq.Table`1<V2.PaidTimeOffDAL.ENTUse rAccount>' could be found (are you missing a using directive or an assembly reference?) C:\Users\x2ws\Documents\Visual Studio 2008\Projects\PaidTimeOffSolution\PaidTimeOffUI\De fault.aspx.cs 34 28 http://localhost/PaidTimeOffUI/"

"Error 4 'System.Data.Linq.Table`1<V2.PaidTimeOffDAL.ENTUse rAccount>' does not contain a definition for 'SubmitChanges' and no extension method 'SubmitChanges' accepting a first argument of type 'System.Data.Linq.Table`1<V2.PaidTimeOffDAL.ENTUse rAccount>' could be found (are you missing a using directive or an assembly reference?) C:\Users\x2ws\Documents\Visual Studio 2008\Projects\PaidTimeOffSolution\PaidTimeOffUI\De fault.aspx.cs 36 28 http://localhost/PaidTimeOffUI/"

I am using the following in my default.aspx.cs file:

Code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using V2.PaidTimeOffDAL;

Any help is greatly appreciated.

tkachuk · March 5th, 2009, 08:38 PM

Figured it out, had to add System.Data.Linq as a reference to the Web Site project, not just the solution.

Ciupaz · March 10th, 2009, 05:27 AM

System.Data.Linq is not already present in the "using" statements?

Luigi

AspNew · March 10th, 2009, 10:55 AM

"Using" (think of it as "include" in c/c++) only used during compilation to resolve compile linkages.

You still need to add the system.data.ling to the web reference to tell the application where to find the system.data.ling.dll.

This happens because chapter 2 sample didn't provide the reference, later samples such as chapter 11 did do that.

litlmike · May 14th, 2009, 10:40 AM

I also had this issue, it was kind of an unclear statement in the book.

faeze · August 2nd, 2009, 04:26 AM

hi dear friends,
i membered newly.

i want that read from sqlserver in C#.net.
but function of read() cannot read.
how do i this??
please help me

chroniclemaster1 · August 2nd, 2009, 11:37 PM

Try the tutorials on www.asp.net and the MSDN library. There are even walkthroughs that give you the exact code to use. Or you can google it. There are lots of resources.