Stack Overflow
Stack Overflow

Questions tagged [dblinq]

56 questions
32
votes
4 answers

How do I use a boolean field in a where clause in SQLite?

It seems like a dumb question, and yet. It could be my IDE that's goofing me up. Here's the code (this is generated from DbLinq): SELECT pics$.Caption, pics$.Id, pics$.Path, pics$.Public, pics$.Active, portpics$.PortfolioID FROM main.Pictures…
jcollum
  • 43,623
  • 55
  • 191
  • 321
11
votes
2 answers

How mature is dblinq?

Im working on an application that needs to talk to a database. The application is written in C#. Im quite taken by LINQ and auto generating classes to represent the database and its tables, so first I considered using SQL as .NET only comes with…
Bas Smit
  • 645
  • 1
  • 7
  • 19
8
votes
3 answers

Why is it possible to enumerate a DbLinq query after calling Dispose() on the DataContext?

Update - The answer is apparently that DbLinq doesn't implement Dispose() properly. D'oh! The below is all sort of misleading - Bottom line: DbLinq is not (yet) equivalent to LinqToSql, as I assumed when I originally asked this question. Use it…
devuxer
  • 41,681
  • 47
  • 180
  • 292
6
votes
4 answers

Would an ORM have any way of determining that a SQLite column contains date-times or booleans?

I've been thinking about using SQLite for my next project, but I'm concerned that it seems to lack proper datetime and bit data types. If I use DbLinq (or some other ORM) to generate C# classes, will the data types of the properties be "dumbed…
devuxer
  • 41,681
  • 47
  • 180
  • 292
5
votes
1 answer

Why are binary Guids different from usual representation

I have the following Guid: AAB13E97-449B-4D5B-BDE2-AC479C31B782 Using System.Guid + DbLinq + SQLite to store it the following field is added to the database. 973EB1AA-9B44-5B4D-BDE2-AC479C31B782 (Dashes added for clarity) I can see that the last 8…
Jader Dias
  • 88,211
  • 155
  • 421
  • 625
4
votes
1 answer

How to do left outer joins with DbLinq and SQLite?

I tried db.Table1.GroupJoin(db.Table2, t1 => t1.Id, t2 => t2.t1Id, (t1,g) => new { t1, g }) .Where(item => !item.g.Any()) .Select(item => item.t1); But it returned 0 results. I'm trying to write something that generated the…
Jader Dias
  • 88,211
  • 155
  • 421
  • 625
4
votes
5 answers

How to select null values with LINQ to SQL and DbLinq?

When I bool? isApproved = null; db.Table.Where(item => item.IsApproved == isApproved).Count(); the last line value is 0. But when I db.Table.Where(item => item.IsApproved == null).Count(); the value is correct. I'm using SQLite, DbLinq and…
Jader Dias
  • 88,211
  • 155
  • 421
  • 625
4
votes
1 answer

Will using dblinq to SQLite in a Windows Store app pass store validation?

I've been trying to figure out how to get a decent LINQ to something working for ORM database access in a Windows Store app. All I've found is SQLite and the sqlite-net NuGet package. The latter sucks a bit, as I don't get any .dbml like structure…
SabbeRubbish
  • 61
  • 1
  • 8
3
votes
2 answers

DBLinq not generating where clause

I'm testing out DBLinq-0.18 and DBLinq from SVN Trunk with MySQL and Postgresql. I'm only using a very simple query but on both database DBLinq is not generating a Where clause. I have confirmed this by turning on statement logging on Postgresql to…
sipsorcery
  • 30,273
  • 24
  • 104
  • 155
3
votes
1 answer

How can i use DBLinq >> DBMetal tool with sqlite?

Please provide samples of command line tool dbmetal to generate code file from a sqlite database.
Jitesh Patil
  • 1,334
  • 1
  • 8
  • 13
3
votes
4 answers

Converting MySQL DATETIME to System.DateTime

I am using a MySQL database with DbLinq, but there is an exception being thrown: "Cannot convert mysql datetime to system.datetime" How can I resolve this issue?
pius
  • 31
  • 1
  • 2
3
votes
4 answers

LINQ to PostgreSQL errors when using DbLINQ

I'm using LINQ to SQL (PostgreSQL) via DbLINQ. I have a problem doing LINQ to PostgreSQL. I succesfully generated .dbml and .cs files with dbmetal and I think I got all the references, the code…
user1941235
  • 113
  • 1
  • 10
2
votes
1 answer

Code sample using DBLinq, SQLite

Would someone be able to post a small code sample that has a working connection using DBLinq, SQLite? I have been struggling to get this up and running in a VS 2010 WPF environment for 2 days now. I think I have the connection string worked out,…
Mark
  • 3,123
  • 4
  • 20
  • 31
2
votes
1 answer

Linq-Sql Oracale object relational data type, is it possible?

I have recently been trying to set up a .Net application which will connect to an oracle database using object relational data types, I would like to do this using the Linq-Sql framework, however when using tools such as DbLinq it does not seem to…
Alex Hope O'Connor
  • 9,354
  • 22
  • 69
  • 112
2
votes
1 answer

Dblinq reference in ASP.NET Web Service on MonoDevelop causes xsp2 to fault

I am trying to try DBLinq with the sqlite provider inside a simple ASP.NET web service. I am also using MonoDevelop 2.4 and Mono 2.6.7, The project in monodevelop references the DbLinq.dll which by default is set to be Local Copy. I can…
ell
  • 21
  • 3
1
2 3 4