Started using the LINQ book. I downloaded SQL Server 2008 Express.
I also downloaded AdventureWorks 2008R Database files. My problem is with the example beginning on page 9 of the book, it is referring to Database called AdventureWorks which I do not have. Then looking for Table DirectoryInformation.

I have several AdventureWorks databases that got downloaded but none are just plain AdventureWorks.

Am I supposed to be looking for some older version?

hello there
I dont have the book so Im not sure about DS version but u may find it in MSDN or http://msftdbprodsamples.codeplex.com/
remember we have a new version of AdventureWorks in 2008 witch is a bit simple u can download ur AdventureWorks & go with samples

HTH

__________________
Always,
Hovik Melkomian.

Okay, I need a little more help. Got the database solved the next day. Been working on something since. Still on the same page in book.

The code they use is as follows:
AdventureWorks db = new AdventureWorks("Integrated Security=sspi");


[Database(Name = "AdventureWorks")]

public class AdventureWorks : DataContext
{
//public Table<DirInfo> DirectoryInformation;
public AdventureWorks(string connection) : base(connection) { }
public Table<DirectoryInformation> DirectoryInformation;


}

[Table(Name = "DirectoryInformation")]
public class DirectoryInformation
{
[Column(DbType="varchar(50)")]
public string DirectoryName;

[Column(DbType = "varchar(255)")]
public string DirectoryDescription;
}



They then read and use the records in the database.
My problem is this, where (how) are they telling it where the database resides?
The book continues on as if I have already done so. It cannot find the database and create an instance of it especially since it has no idea where it is.
They are not showing me any connection string or where to use it in their example.

Can anyone help me with this?
Thank you.

Okay, lets try something different.
Still on same page for 4 weeks now, no help here so far, try once more.
Connecting to database okay but get SqlException Invalid object name DirectoryInformation when trying to query the table.

Does anyone have any suggestions?

Hi there,

You can assign a connection string to the constructor of the DataContext. E.g. rather than specifying:

"Integrated Security=sspi"

you should be able to pass something like this instead:

Data Source=.\SqlExpress;Initial Catalog=AdventureWorks;Integrated Security=True;

which points to a local instance of SQL Server called SqlExpress which should already have the AdventureWorks database attached to it.

For info about attaching database, take a look here: http://imar.spaanjaars.com/395/confi...ql-server-2005

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Thank you very much Imar.
The link you sent was very helpful along with your code suggestion.
Gives me choices to play with and get more understanding.