Subsonic 3: Update problem

subsonicsubsonic3

I am using SS 3.0.0.3 ActiveRecord. This query:

new Update<BillDetail>(provider)
    .Set(bd => bd.DivisionDetails == divisionDetails)
    .Where(bd => bd.BillNumber == documentId && bd.IsInvoice == true);

produces this SQL:

UPDATE `BillDetails` 
 SET `DivisionDetails`=@up_DivisionDetails
 WHERE `BillNumber` = @0

Where did the IsInvoice part go? Am I doing something wrong here?

Best Answer

Had this problem in previous releases but it was fixed - you sure you're using 3.0.0.3?

Related Solutions

Failed to resolve include text for file:SQLServer.ttinclude

I just wanted to close this issue. Please Not UNC paths don't play nice with subsonic. If you can. Work with your project outside of a UNC path or do some fun research and customize subsonic to fit your needs.

Subsonic 3 Simple Query inner join sql syntax

So far my experience with 3.0.0.3 suggests that this is not possible yet with the query tool, although it is with version 2.

I think the preferred method (so far) with version 3 is to use a linq query with something like:

var busUnits = from b in BusinessUnit.All()
join u in UserBusinessUnit.All() on b.Id equals u.BusinessUnitId
select b;

Best Answer

Related Solutions

Failed to resolve include text for file:SQLServer.ttinclude

Subsonic 3 Simple Query inner join sql syntax

Related Topic