Error executing sqlmetal against SQL2005

[Joern Schou-Rode]

I am trying to execute the sqlmetal util with the following command line
arguments

/provider:SQL2005 /database:bookshelf_dev /code:SqlMetal.cs

This gives me the following error:

Error : Could not load type 'System.Data.Linq.SqlClient.Sql2008Provider'
from assembly 'System.Data.Linq, Version=3.5.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089'.

I cannot seem to find any information on the web regarding this problem.
Does anyone have a clue whats going on here?

It's telling me something about an Sql 2008 provider, but I did explicitly
ask for Sql 2005. Do I have to install some kind of Sql 2008 client tools to
make sqlmetal work?

 

[Joern Schou-Rode]

Error : Could not load type 'System.Data.Linq.SqlClient.Sql2008Provider'
from assembly 'System.Data.Linq, Version=3.5.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089'.

Update: When I tell sqlmetal to generate the XML mappings file, it works
like a charm. When I afterwards tell sqlmetal to generate code from the
XML mapping, I get the very same error as before. This indicates that the
exception is thrown as sqlmetal is about to cook up the code, rather than
while inspecting the database.

I really hope someone has an idea on what to do or where to look for a
solution to this problem.

Thanks in advance!

 

[Joern Schou-Rode]

Problem solved. After installing the "Windows SDK for Windows Server 2008
and .NET Framework 3.5" package SqlMetal is up and running.

Why the SqlMetal binary in the 6.0A version (distributed with VS2008) did
not work I cannot say.