Piotr Jarocki
Posted
on Sep 17, 2011
(permalink)
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
Reply
Damyan Bogoev
Damyan Bogoev
Posted
on Sep 19, 2011
(permalink)
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.
Reply
Damyan Bogoev
Damyan Bogoev
Posted
on Sep 20, 2011
(permalink)
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.
Reply
Piotr Jarocki
Posted
on Sep 20, 2011
(permalink)
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)?
Reply
Damyan Bogoev
Damyan Bogoev
Posted
on Sep 21, 2011
(permalink)
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.
Reply
Piotr Jarocki
Posted
on Sep 29, 2011
(permalink)
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
Reply
Answer
Damyan Bogoev
Damyan Bogoev
Posted
on Oct 3, 2011
(permalink)
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.
Reply
Piotr Jarocki
Posted
on Oct 4, 2011
(permalink)
thanks ;) now its all working as it should
Reply