Is SubSonic's CodingHorror the only way to do WHERE ISNULL?

Posted by cantabilesoftware on Stack Overflow See other posts from Stack Overflow or by cantabilesoftware
Published on 2010-06-02T01:37:41Z Indexed on 2010/06/02 1:43 UTC
Read the original article Hit count: 398

Filed under:

subsonic

|

subsonic3

I'm trying to do a simple UPDATE ... WHERE ISNULL() using SubSonic ActiveRecord and the only way I can get it to work is by using CodingHorror. eg:

    public void MarkMessagesRead(long? from_person)
    {
        if (from_person.HasValue)
        {
            _db.Update<message>()
                .Set(x => x.is_read == true)
                .Where(x => x.from_id == from_person && x.to_id == people_id)
                .Execute();
        }
        else
        {
            new SubSonic.Query.CodingHorror(_db.DataProvider, "UPDATE messages SET is_read=1 WHERE ISNULL(from_id) AND to_id=@toid", people_id).Execute();
        }
    }

Am I missing something?

© Stack Overflow or respective owner

Related posts about subsonic

subsonic.migrations and Oracle XE

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, Probably I'm doing something wrong but here it goes: I'm trying to create a database using subsonic.migrations in an OracleXE version 10.2.0.1.0. I have ODP v 10.2.0.2.20 installed. This is my app.config: <?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> … >>> More
SUBSONIC 3.0.0.3 Subsonic.Query.SqlQuery

as seen on Stack Overflow - Search for 'Stack Overflow'
New to subsonic and having issues figuring it out. I am simply just trying to do a distinct search and any documentation I find is telling me to use the class/method SubSonic.SqlQuery Though I am finding out that since I am using the newest version, a lot of the documentation I am finding does not… >>> More
Error with SubSonic 2.0.3

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have to work on an application which used Subsonic 2.0.3. When I opened the project,I got a message The projectfile 'C:\Program Files\Subsonic\Subsonic 2.0.3\src\SubSonic\SubSonic.csproj' has been moved, renamed or is not on your computer. Does it mean I need to install Subsonic 2.0.3, I… >>> More
Benchmark Linq2SQL, Subsonic2, Subsonic3 - Any other ideas to make them faster ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working with Subsonic 2 more than 3 years now... After Linq appears and then Subsonic 3, I start thinking about moving to the new Linq futures that are connected to sql. I must say that I start move and port my subsonic 2 with SubSonic 3, and very soon I discover that the speed was so slow… >>> More
Saving record in Subsonic 3 using Active Record

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having trouble saving a record in Subsonic 3 using Active record. I've generated my objects using the DALs and tts and everything seems fine because the following test passes. I think that my connection string is correct or the generation wouldn't have succeeded. [Test] public void… >>> More

Related posts about subsonic3

How to log subsonic3 sql

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm starting to develop a new asp.net application based on subsonic3 (for queries) and log4net (for logs) and would like to know how to interface subsonic3 with log4net so that log4net logs the underlying sql used by subsonic. This is what I have so far: public static IEnumerable<arma_ocorrencium>… >>> More
Left Join in Subsonic3

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I'm new in subsonic3, and I'm getting some errors when I try to use LeftJoin var q = from c in categories join p in products on c equals p.Category into ps from p in ps.DefaultIfEmpty() select new { Category = c, ProductName = p == null ? "(No products)" : p.ProductName… >>> More
Help with Subsonic3 ActiveRecord LINQ query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following subsonic entities TInvoiceHeader TAccountAssociation How can I achieve the following in LINQ (subsonic) SELECT * from TInvoiceHeader WHERE custid IN (SELECT custid FROM TAccountAssociation WHERE username = 'a') I need to bind the results to a GridView. >>> More
Help with Subsonic3 LINQ query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following subsonic entities TInvoiceHeader TAccountAssociation How can I achieve the following in LINQ SELECT * from TInvoiceHeader WHERE custid IN (SELECT custid FROM TAccountAssociation WHERE username = 'a') I need to bind the results to a GridView. >>> More
Using constructor to load data in subsonic3?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm getting an error while trying to load an record through the constructor. The constructor is: public Document(Expression<Func<Document,bool>> expression); and i try to load a single item in like this var x = new Document(f=>f.publicationnumber=="xxx"); publicationnumber isn't… >>> More