Tagged Questions
0
votes
0answers
13 views
when i drag and drop stored procedure onto my dbml file(VS 2010) and save it creates another designer1.cs file
In my project i have data-access layer which contains dbml file(named test.dbml) used to drag and drop stored procedure and tables. 2 days ago strange thing happened when i drag and drop stored ...
0
votes
2answers
51 views
dbml changes the type of varbinay(max) on Sql Server to Systm.Data.Linq.Binary but not byte[]
I have some table in Sql Server which has VarBinary(MAX) and I want to upload files to them, I need to make the Dbml to make the field byte[] but instead I get Systm.Data.Linq.Binary.
Why is that and ...
0
votes
1answer
57 views
LINQ to SQL getting Type and Length
I've been tasked with finding the Type and Length of a specific column from the DBML.
I would like to pass in the DataContext, TableName and then ColumnName to return my values that I'm looking ...
1
vote
1answer
46 views
would changing dbml to bigint work for int values
our db is undergoing migration from int to bigint. In migrated partitions I have a column name in a table that is stored as bigint and in other partitions it is stored as int(to be migrated). ...
0
votes
2answers
68 views
how can i select ONLY the first row of this dbml query?
this is my original query
public UserChallenge GetUserChallenge(int userId, int challengeId)
{
var result = from userChallenge in DataContext.UserChallenges
...
0
votes
1answer
92 views
Linq 2 SQL - Inheritance Multiple SQL Statements
Whilst implementing the AdventureWorks db in a sample application using Linq 2 SQL i've ran into a problem with the way in which Linq 2 SQL generates SQL statements for derived types in the ...
0
votes
1answer
87 views
DataContext seems to be pulling 2 copies of the same record from the database
I have a DataContext that seems two be pulling two copies of the same record out of the database. There's only one record of this kind in the database.
Here the code that is doing it:
...
0
votes
1answer
47 views
Method not Found error when updating SQL Compact db and dbml for linq to sql
I have a vb.net app that uses linq to sql with a SQL Compact database. I just updated a date field in the database to be nullable and regenerated the dbml using sqlmetal. Now when I run the ...
0
votes
1answer
61 views
How do I hook up classes to my Linq-to-Sql?
Linq / Linq-to-Sql / C# newbie question, but I can't seem to find any useful information on it. It is possible I'm not phrasing the question correctly. Any help appreciated.
So, I have some existing ...
3
votes
1answer
164 views
Add column in database then update the dbml
I have an application that have a dynamic table in database. The problem is, let say there's a change in table structure like addition of column, can I update the dbml file dynamically? so I don't ...
0
votes
1answer
114 views
Add column to database and reflect in DBML file Invalid Column name error
I have a huge .dbml file.
I need to add a column to a Contact table for storing a datetime which will then later be used to determine if the contact should be displayed or not.
I added the column to ...
0
votes
1answer
104 views
Force linq dbml file to get database values
I have two sites, one administration site, where i can edit all the values in a database, and a public site that only reads the data from the database.
Both the site have identical dbml files to work ...
1
vote
1answer
42 views
Linq2Sql Buildtime takes ages
I am using Linq2Sql to access my database which is fairly large. (67 tables)
It's quite a pain in the butt to work with currently because it takes ages for the "MSLinqToSQLGenerator" to generate it's ...
1
vote
2answers
153 views
Linq making primary key system.nullable<int> not just int
I'm mapping my database into base object with Linq to SQL. I drag all the tables into my dbml and they all setup nicely. I save the dbml and it creates the classes that represent the tables, etc.
...
1
vote
0answers
160 views
Foreign Key Causes WCF Socket Connection to Abort
I have 2 tables, Unit and SubUnit, with a one to many relationship: a Unit can have 0 or more SubUnits.
I use Linq to SQL (.dbml files) in a WCF Windows Service to access the database.
Using the ...
