Page 1 of 1
Create index
Posted: Mon 02 Jun 2014 22:33
by Dabassman
Hi there,
I am currently testing entity developer. I am using the vs plugin in studio 2013 to create a model-first data model for ef 6.
How can i create an index for a column that is not the primary key?
Kind regards
matthias
Re: Create index
Posted: Tue 03 Jun 2014 14:36
by Shalex
You are working with SQL Server, aren't you?
Please specify which indices you want to create: the type (UNIQUE/CLUSTERED/NONCLUSTERED), amount of columns in the index, etc.
Re: Create index
Posted: Tue 24 Jun 2014 10:12
by Dabassman
I am working with sql server, correct.
In general, I want to create indexes, as far as supported by sql server.
For now, I need indexes over one or two columns, normally nonclustered.
Special case may be an index over a geography column.
Kind regards
Matthias
Re: Create index
Posted: Tue 24 Jun 2014 14:38
by Shalex
Thank you for your feedback. Our road map includes an implementation of the functionality of setting indices via Entity Developer. There is no timeframe at the moment. We will notify you when the feature is implemented.
Re: Create index
Posted: Wed 02 Aug 2017 20:37
by gr8user
Hi,
Could you please confirm has been implemented "setting indices via Entity Developer"?
I tried to create index for Oracle DB and didn't get any result.
Thanks,
Re: Create index
Posted: Thu 03 Aug 2017 13:44
by Shalex
Entity Developer doesn't retreive information about indices in database (and doesn't create them). There is no timeframe for this feature at the moment.
Re: Create index
Posted: Sun 24 Sep 2017 09:38
by PixelHunter
Would be great to have this feature!
Proper indexes are mandantory for performant dbs.
Maintaining them manually is pontential area for failures.
Best Florian
Re: Create index
Posted: Mon 25 Sep 2017 09:18
by Shalex
Re: Create index
Posted: Mon 02 Oct 2017 22:54
by maubuso
Sorry, but the uservoice feature exists since may, 2013. The second most voted feature. But nothing change since that. Four long years ...
Index missing feature is a huge problem in big projects.
Re: Create index
Posted: Thu 05 Oct 2017 13:09
by Shalex
Thank you for your feedback. We will investigate the possibility of implementing this feature.
Re: Create index
Posted: Tue 10 Apr 2018 18:59
by maubuso
Hi. Any news about Index? Why vote if Devart do not apply users voice ?
Re: Create index
Posted: Thu 12 Apr 2018 17:55
by Shalex
ORM oriented constraints (PK, FK, Unique) are supported by Entity Developer because the generated ORM mapping depends on the constraints in the database. In case of indices, there is no dependency between existence and type of index and ORM mapping.
Entity Developer supports
multiple database servers, indices types and their settings are database specific. Taking into account a unified interface in Column Editor for all servers, it's not clear how to represent all possible options.
You should use some database management IDE (
dbForge Studio for SQL Server, etc) to control indices via special Index Manager, it is designed for this purpose.
Entity Developer is not a database management tool, it is ORM mapping and code generation tool.