Questions tagged [dblinq]
56 questions
0
votes
1 answer
How should I correctly compose my Linq query where the condition is set to a foreign entity
The following are sample data for the purpose of explaining this matter:
tblPrimary
1, John, 2011-01-03T11:12:00z
2, John, 2011-02-04T10:54:12z
tblDetail:
1, 1, 14, Dept01
2, 1, 12, Dept02
3, 2, 10, Dept03
4, 2, 17, Dept04
Using the above example…
0
votes
1 answer
Using DB_LINQ for PostgreSQL and C#
Dear..
I want to use postgresql as database and when I was do google I found Db_Linq to connect postgresql as LinQ.
But when I install it, I confused how to do it..
First, I download solution and compile and then I type it on command prompt…
Gianni Rivera
- 95
- 2
- 7
0
votes
2 answers
How can I find out the exact query that gets executed with LINQ to SQL in DbLinq and SQLite?
I'm using DbLinq with SQLite for a small project of mine. Is there any way to look at the actual SQL queries that get executed behind the scenes?
I remember a monitoring program for SQL Server from my internship but SQLite is a quite different…
Joey
- 344,408
- 85
- 689
- 683
0
votes
1 answer
Changing language/culture in a MySQL/Dblinq project
I'm not very familiar in programming databases, but I have a Mysql-Database which I access with Dblinq under C#. Now when I enter dates, numbers etc, the english notation is used, but my customer needs german. How can I switch my database from…
Badeoel
- 197
- 2
- 13
0
votes
1 answer
DBLinq for a production system?
We're working on an ASP.NET web application with C# code behind. The database is MySQL 5.1 using InnoDB. The data access layer uses ADO.NET to call stored procedures and then builds various data structures out of the result sets (no object…
JohnB
- 18,046
- 16
- 98
- 110
0
votes
2 answers
How to fix unreachable code dedected warning
dbLinq XMlMappingSource.cs contains code:
public void ReadEmptyContent(XmlReader r, string name)
{
if (r.IsEmptyElement)
r.ReadStartElement(name, DbmlNamespace);
else
{
r.ReadStartElement(name,…
Andrus
- 26,339
- 60
- 204
- 378
0
votes
1 answer
Does DbLinq supports SQLite3?
I have a small project that requires minimal storage. So i choose SQLite3. I'm not much familiar with LINQ. I noticed DBLinq supports Linq. But i'm not sure that supports SQLite3 as DBLinq stooped development long ago.
Hemanth
- 177
- 2
- 11
0
votes
1 answer
Object is reinserted into database immediately after delete (DbLinq)
I have a MySql database, whose general structure looks like this:
Manufacturer <== ProbeDefinition <== ImagingSettings
ElementSettings ====^ ^==== ProbeInstance
I'm using InnoDB to allow foreign keys, and all foreign keys pointing to a…
Will Eddins
- 13,628
- 5
- 51
- 85
0
votes
1 answer
DbLinq DbMetal - "The given key was not present in the dictionary" when adding Foreign Key
This is my initial SQLite database
CREATE TABLE [Categories] (
[ParentId] INT,
[Name] VARCHAR(100));
CREATE TABLE [Fees] (
[CategoryId] INT,
[Name] VARCHAR(100),
[Value] VARCHAR(50),
[Info] VARCHAR(200));
CREATE TABLE [Markups] (
…
Aximili
- 28,626
- 56
- 157
- 216
0
votes
0 answers
Can't delete child entities with DbLinq
This question is related to my previous one. You can find pretty much all the code there, with the exceptions reported here. I replaced nullable fields with int fields and where the generated code put null I put -1. In this way I managed to solve…
Totem
- 454
- 5
- 18
0
votes
1 answer
DbLinq "char" special character
I used the DbMetal tool to generate a class for my database. It worked, but then I added some "char" types to the database. Now when I try to generate the class I get the error
DbMetal : Don't know how to convert the SQL type '"char"' into a…
robertpas
- 643
- 5
- 12
- 25