Create index

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
Dabassman
Posts: 3
Joined: Sat 03 May 2014 01:05

Create index

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
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Create index

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
Posts: 3
Joined: Sat 03 May 2014 01:05

Re: Create index

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
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Create index

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
Posts: 16
Joined: Wed 24 Aug 2016 23:45

Re: Create index

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
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Create index

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
Posts: 8
Joined: Thu 29 Jun 2017 11:07

Re: Create index

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
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Create index

Post by Shalex » Mon 25 Sep 2017 09:18


maubuso
Posts: 30
Joined: Wed 02 Jan 2013 23:53

Re: Create index

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
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Create index

Post by Shalex » Thu 05 Oct 2017 13:09

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

maubuso
Posts: 30
Joined: Wed 02 Jan 2013 23:53

Re: Create index

Post by maubuso » Tue 10 Apr 2018 18:59

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

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Create index

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.

Post Reply