Page 1 of 1
LinqConnect Professional Version 4.2.229 (18-Apr-2013) - How use Indexes?
Posted: Tue 21 May 2013 09:07
by AKRRKA
Hello,
I need use index, but dont found how can i do it?
By sample:
1) For MySQL:
Code: Select all
ALTER TABLE `Values` ADD INDEX `DT` (`DT`);
1) For SQL Server:
Code: Select all
CREATE INDEX [IX_Values] ON [dbo].[Values]
([DT] ASC)
ON [PRIMARY]
GO
How can i do it with Entity Developer?
PS: Already have model.
Thanks.
Re: LinqConnect Professional Version 4.2.229 (18-Apr-2013) - How use Indexes?
Posted: Tue 21 May 2013 11:57
by MariiaI
There is no way to work with indexes via Entity Developer.
You could create indexes explicitly via the
ExecureQuery/
ExecuteCommand methods.
Re: LinqConnect Professional Version 4.2.229 (18-Apr-2013) - How use Indexes?
Posted: Tue 21 May 2013 15:56
by AKRRKA
Please give an example of how to do it.
I have one model for different databases. The context is loaded dynamically based on user selection at the start of the program.
Re: LinqConnect Professional Version 4.2.229 (18-Apr-2013) - How use Indexes?
Posted: Thu 23 May 2013 06:21
by MariiaI
We have sent you a simple test project to the e-mail address you have provided in your forum profile. Please check that the letter is not blocked by your mail filter.
Please test it and notify us about the results.
Re: LinqConnect Professional Version 4.2.229 (18-Apr-2013) - How use Indexes?
Posted: Mon 27 May 2013 06:01
by AKRRKA
This is very inconvenient. I had to make composite keys.
You do not plan to implement the work with the indices directly in the developer?
Re: LinqConnect Professional Version 4.2.229 (18-Apr-2013) - How use Indexes?
Posted: Mon 27 May 2013 08:45
by MariiaI
At the moment, there are no plans to add this support. You can post your suggestion at our
UserVoice so that other users can vote for it.
Re: LinqConnect Professional Version 4.2.229 (18-Apr-2013) - How use Indexes?
Posted: Mon 27 May 2013 11:27
by AKRRKA
Ok.
Link to vote:
Work with indexes via Entity Developer
Please vote who also need it.
Thanks.
Re: LinqConnect Professional Version 4.2.229 (18-Apr-2013) - How use Indexes?
Posted: Mon 12 Aug 2013 10:00
by AKRRKA
Maybe this article will help you quickly realize the idea.
Article in Russian, but I think for you it's not a problem.
Entity Framework Code First — индексация полей и полнотекстовый поиск
Re: LinqConnect Professional Version 4.2.229 (18-Apr-2013) - How use Indexes?
Posted: Tue 13 Aug 2013 06:47
by MariiaI
Thank you for your involvement. We will examine this article.