I'm trying to connect to my local Sql Server Express 2008 R2 instance (v 10.50.1600) to generate classes via sqlmetal.exe (1.00.30729) and I get the following error: Error : Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed. I can connect via S...
Edit - Cleaning up question to better reflect the actual issue: I'm using SQLMetal to generate database classes from our SQL Server db. Recently, I needed to add a table that had multiple foreign keys pointing to the same table. Using LINQPad to play around with the new tables, I was able to access properties for both foreign keys like ...
I am using sqlmetal on Ubuntu Linux and want to generate the dbml for a sqlite database that has just 2 tables created as follows: CREATE TABLE "user" ( "uid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" TEXT NOT NULL ); CREATE TABLE "bridge" ( "pkey" INTEGER NOT NULL, "rkey" INTEGER NOT NULL, "location" TEXT, PRIMARY KEY (pkey...
Hi, In my project I create the Linqto-SQL Classes using SqlMetal. The problem with this is that SqlMetal doesnt appear to create a parameterless constructor. I've always got round this because in my code I can always get the default connectionstring name and pass it to the constructor, however now I am being forced to use a linqdatasour...