Full text search in Subsonic

subsonic

In subsonic v2 I can use inline query for full text search in sql server 2008, like this:

DB.Query().ExecuteTypedList<Product>("select * from Product where contains(*, @order)", queryString);

all this works fine.

But now I would like to move on subsonic v3, so I'm trying to get results through SqlQuery, but ExecuteTypedList return an null reference exception:

        SubSonic.Query.SqlQuery inlineQuery = new SqlQuery();
        inlineQuery.SQLCommand = string.Format("select * from Product where contains(*, '{0}')", queryString);
        return inlineQuery.From("Product").ExecuteTypedList<Product>();

PLease prompt me? how I can execute inline query in subsonic v3, to get List<> not a reader

Best Answer

answer is:

return new CodingHorror(string.Format("select * from Product where contains(*, '{0}')", queryString)).ExecuteTypedList<Product>();

Related Solutions

R – subsonic preload object and child

I use the RepositoryRecord in SubSonic which is "mostly" poco. Then I make partials for those classes that load the other class when a property is selected. Besides, loading one record from the database is faster and easier than loading them all at once.

Partial Public Class Book

    Private _Author as Database.Author 
    Property Author() as Database.Author
      Get
         If _Author is nothing then
           ' Load the author class here.
         End if
         return _Author
      End get
      Set
         '....
      End Set
    End Property

End Class

Outer join with AndExpression

The key is the difference in the AND [orders].[deptid] = 2 and the WHERE [orders].[deptid] = 2, which off course will result in 2 different resultsets.

Both will return the same resultset. There may be some performance difference, but i dont thinks, so. as modern database, optimize the query better.

Best Answer

Related Solutions

R – subsonic preload object and child

Outer join with AndExpression

Related Topic