dblinq

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 beast, I fear. ...

problem with linq to sqlite

I am using vb.net sqlite.net and dblinq0.20.1 to search a sqlite table on a primary key field. My code looks like this Dim blb = (From d In db.Data Where d.UID = myuid Select d).Single This returns the error "Coalesce used with type that cannot be null" If I search on a nullable field it works fine. Anyone come across this error ...

MySQL timestamp to .NET timestamp

Hi all, I am using DBLinq to access a MySQL DB from C# .NET 3.5 I have created the dbml file for the Visual Studio 2010 ORM, and it loads fine - however when I compile the source I am met with errors regarding the conversion of MySQL timestamp to .NET DateTime. Now this kind of makes sense, because they are 2 'different' types (Though...

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 compile the webservice just fine. By when I try to run it from Monodevelop or using the xsp2 f...