full text search with postgresql

8 posts, 1 answers
  1. Piotr Jarocki
    Piotr Jarocki avatar
    16 posts
    Member since:
    Feb 2010

    Posted 17 Sep 2011 Link to this post

    Hi,
    is there a way to create full text search field using OpenAccess Domain Model? and how how to use it later in linq?

    Regards,
    Piotr Jarocki
  2. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 19 Sep 2011 Link to this post

    Hello Piotr Jarocki,

    Unfortunately OpenAccess ORM does not support this feature.
    I am sorry for the inconvenience caused.

    Regards,
    Damyan Bogoev
    the Telerik team
    Want to use Telerik OpenAccess with SQL Azure? Download the trial version today. 
  3. DevCraft banner
  4. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 20 Sep 2011 Link to this post

    Hello Piotr Jarocki,

    Actually you could perform full-text search using OpenAccess ORM with a bit of SQL:
    var query = from p in context.ProductName where "FREETEXT ({0},{1})".SQL<bool>(p.ProductName, 'spread') select p;
    You could find useful the new Low Level (ADO API) for Fetching Data Efficiently introduced in the latest release of the product.
    Hope that helps.

    Greetings,
    Damyan Bogoev
    the Telerik team
    Want to use Telerik OpenAccess with SQL Azure? Download the trial version today. 
  5. Piotr Jarocki
    Piotr Jarocki avatar
    16 posts
    Member since:
    Feb 2010

    Posted 20 Sep 2011 Link to this post

    ill check it later :)
     but another question is, if there is a possibility to create index using domain model? Im not talking about full text index now, but normal index (not primary key)?
  6. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 21 Sep 2011 Link to this post

    Hello Piotr Jarocki,

    I am afraid that you are unable to create/edit/delete indexes using the visual designer.
    You could use a management tool for PostgreSQL to achieve that goal.

    All the best,
    Damyan Bogoev
    the Telerik team
    Want to use Telerik OpenAccess with SQL Azure? Download the trial version today. 
  7. Piotr Jarocki
    Piotr Jarocki avatar
    16 posts
    Member since:
    Feb 2010

    Posted 29 Sep 2011 Link to this post

    hi,
    could you tell me if i should include some namespaces to make this work " var query = from p in context.ProductName where "FREETEXT ({0},{1})".SQL<bool>(p.ProductName, 'spread') select p;"  ?? because i cant use .SQL

  8. Answer
    Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 03 Oct 2011 Link to this post

    Hello Piotr Jarocki,

    The SQL<T>(params object[] arguments) extension method is defined in the Telerik.OpenAccess.35.Extensions assembly under the Telerik.OpenAccess namespace.
    Please add reference to this assembly as well as include the namespace in the code file where you try to use the extension method.
    Hope that helps.

    Regards,
    Damyan Bogoev
    the Telerik team
    Want to use Telerik OpenAccess with SQL Azure? Download the trial version today. 
  9. Piotr Jarocki
    Piotr Jarocki avatar
    16 posts
    Member since:
    Feb 2010

    Posted 04 Oct 2011 Link to this post

    thanks ;) now its all working as it should
Back to Top
DevCraft banner