For questions specifically about the linq-to-sql dbml file (structure or location) generated by SqlMetal or Visual Studio. Questions about linq-to-sql should be tagged by the [linq-to-sql] tag.
Questions tagged [dbml]
82 questions
0
votes
2 answers
LINQ: Cannot convert short to short?
Cannot implicitly convert type 'short?' to 'short' at LocalAmount = t.EmpNo. I used Convert.ToInt16(t.EmpNo) but then the 'join' clause will get an error and be "incorrect", "type inference failed..."
public class AccountTransaction
{
…
Programming Dreamer
- 235
- 3
- 14
0
votes
2 answers
How to create one linq2sql schema with many object diagrams
Is there any way to create a linq2sql schema (*.dbml-file) in VS2012 with many object diagrams for different parts of the database. For instance one diagram for customer related tables and another diagram for product related tables.
The problem is,…
0
votes
1 answer
Linq2SQL DBML system Type for Varchar(1)
I am using LINQ2SQL for DB Queries. I wrote a stored procedure and updated the DBML by drag and drop the stored procedure in VS Server Explorer to DBML.
But i got below mapping created by DBML designer
Murali Murugesan
- 22,423
- 17
- 73
- 120
0
votes
1 answer
"Slow" Connection String in dbml?
i have a dbml-file which I use for my linq to SQL.
As i never learned it better, I use the server-explorer from visual studio, insert my database-information there and drag and drop the tables from the db to the dbml file.
The first time I did this…
PassionateDeveloper
- 14,558
- 34
- 107
- 176
0
votes
0 answers
Adding LINQ to SQL (dbml) class reference in .cs file in app code
I have created a Linq(dbml) class wherein i have certain tables, i have saved the class file Now i want to reference that class in .cs file in App_Code. But it does not shows me in the Intellisense. But i am able to use the same class in .aspx.cs…
Abbas
- 4,948
- 31
- 95
- 161
0
votes
4 answers
Generation custom files from dbml file?
I've been having a look at making changes to the partial classes generated from a DBML file. I was reading into using the sqlmetal.exe tool but it appears that you can't do much customisation of what it actually spits out.
I'm wanting to make…
Fermin
- 34,961
- 21
- 83
- 129
-2
votes
1 answer
Normalization in PostgreSQL - share a primary key across tables?
I'm designing a PostgreSQL database that involves three tables: buys, sells, and transaction_pairs. In each of the buys and sells tables I have a unique identifier column id.
database schema
In the pairs table, I have buy_id and sell_id columns…
