Mysql-specific query in SubSonic

subsonic

I'd like to add a query to my SubSonic DAL that uses the MySQL fulltext search construct "WHERE MATCH (columnlist) AGAINST (searchterm)", but can't find an equivalent in SubSonic.

Is there a way of using Subsonic to execute a "literal" query – i.e. it just queries with the exact MySQl code I feed it?

Alternatively, could I implement a subclass of SubSonic.Where to run the fulltext search? If so, how would I go about this?

I'm using SubSonic 2.x. Any ideas welcome. Thanks.

ddoctor

Best Answer

You can use CodingHorror to run any SQL you like.

Related Solutions

Subsonic – Simple Query

Unfortunately you'll need to do this as an inline query as far as I know:

TableCollection tableCollection = new InlineQuery()  
  .ExecuteAsCollection<TableCollection>(
    "SELECT * FROM " + Table.Schema.TableName " WHERE " + Table.Columns.Val1 + " = " + Table.Columns.Val2);

SUBSONIC MYSQL SharedDbConnectionScope TransactionScope

I think your TransactionScope() and SharedDbConnectionScope() are the wrong way round. You have them in the order they were listed in the docs on the SubSonic web site, but there was a discussion on the old SubSonic forum that implied they should be the other way round.

Certainly I use them reversed (I have just posted an extract of my code to another answer on here), but I have to say I only use MSSQL ATM, and can't comment on MySQL.

Best Answer

Related Solutions

Subsonic – Simple Query

SUBSONIC MYSQL SharedDbConnectionScope TransactionScope

Related Topic