I'm using LinqToSQL in a 3.5 framework project in VS2K8, running against MS SQL 2k8.
When I create the table mappings using the design surface within Visual Studio everything works fine.
When I create the table mappings using SQLMetal (from the Windows SDK v6.1), SQLMetal complains about about the SQL Server 2k8 datatypes (e.g. date and time) that I'm making use of.
Does SQLMetal support the SQL Server 2k8 datatypes? Do I need an updated version? Or do I have to create my mapping in the visual designer/revert to SQL Server 2k5 datatypes?
Thanks
As far as i know it supports it, so you probably need a newer version of SqlMetal. In the initial version, when Visual Studio 2008 was launched it was not supporting this so probably that's why you have this problem.
According to MSDN:
The SQLMetal file is included in the Windows SDK that is installed with Visual Studio. By default, the file is located at drive:\Program Files\Microsoft SDKs\Windows\vn.nn\bin. If you do not install Visual Studio, you can also get the SQLMetal file by downloading the Windows SDK.