Create index

Dabassman · Post by **Dabassman** » Mon 02 Jun 2014 22:33

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

Shalex · Post by **Shalex** » Tue 03 Jun 2014 14:36

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.

Dabassman · Post by **Dabassman** » Tue 24 Jun 2014 10:12

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

Shalex · Post by **Shalex** » Tue 24 Jun 2014 14:38

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.

gr8user · Post by **gr8user** » Wed 02 Aug 2017 20:37

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,

Shalex · Post by **Shalex** » Thu 03 Aug 2017 13:44

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.

PixelHunter · Post by **PixelHunter** » Sun 24 Sep 2017 09:38

Would be great to have this feature!

Proper indexes are mandantory for performant dbs.
Maintaining them manually is pontential area for failures.

Best Florian

Shalex · Post by **Shalex** » Mon 25 Sep 2017 09:18

Please vote for this feature at https://devart.uservoice.com/forums/386 ... -developer.

maubuso · Post by **maubuso** » Mon 02 Oct 2017 22:54

Shalex wrote:Please vote for this feature at https://devart.uservoice.com/forums/386 ... -developer.

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.

Shalex · Post by **Shalex** » Thu 05 Oct 2017 13:09

Thank you for your feedback. We will investigate the possibility of implementing this feature.

maubuso · Post by **maubuso** » Tue 10 Apr 2018 18:59

Hi. Any news about Index? Why vote if Devart do not apply users voice ?

Shalex · Post by **Shalex** » Thu 12 Apr 2018 17:55

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.

Devart Forums

Create index

Create index

Re: Create index

Re: Create index

Re: Create index

Re: Create index

Re: Create index

Re: Create index

Re: Create index

Re: Create index

Re: Create index

Re: Create index

Re: Create index