This question is locked. New answers and comments are not allowed.
Piotr Jarocki
Top achievements
Rank 1
Piotr Jarocki
asked on 17 Sep 2011, 08:49 AM
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
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
7 Answers, 1 is accepted
0
Hello Piotr Jarocki,
Unfortunately OpenAccess ORM does not support this feature.
I am sorry for the inconvenience caused.
Regards,
Damyan Bogoev
the Telerik team
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.
0
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
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.
0
Piotr Jarocki
Top achievements
Rank 1
answered on 20 Sep 2011, 08:55 AM
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)?
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)?
0
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
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.
0
Piotr Jarocki
Top achievements
Rank 1
answered on 29 Sep 2011, 05:48 PM
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
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
0
Accepted
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
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.
0
Piotr Jarocki
Top achievements
Rank 1
answered on 04 Oct 2011, 12:38 PM
thanks ;) now its all working as it should