full text search with postgresql

[Piotr Jarocki]

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

[Damyan Bogoev]

Hello Piotr Jarocki,

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

Regards,
Damyan Bogoev
the Telerik team

[Damyan Bogoev]

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

[Piotr Jarocki]

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)?

[Damyan Bogoev]

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

[Piotr Jarocki]

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

[Damyan Bogoev]

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

[Piotr Jarocki]

thanks ;) now its all working as it should