Create index
Create index
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
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
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.
Please specify which indices you want to create: the type (UNIQUE/CLUSTERED/NONCLUSTERED), amount of columns in the index, etc.
Re: Create index
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
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
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
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,
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
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.
-
- Posts: 17
- Joined: Thu 29 Jun 2017 11:07
Re: Create index
Would be great to have this feature!
Proper indexes are mandantory for performant dbs.
Maintaining them manually is pontential area for failures.
Best Florian
Proper indexes are mandantory for performant dbs.
Maintaining them manually is pontential area for failures.
Best Florian
Re: Create index
Please vote for this feature at https://devart.uservoice.com/forums/386 ... -developer.
Re: Create index
Sorry, but the uservoice feature exists since may, 2013. The second most voted feature. But nothing change since that. Four long years ...Shalex wrote:Please vote for this feature at https://devart.uservoice.com/forums/386 ... -developer.
Index missing feature is a huge problem in big projects.
Re: Create index
Thank you for your feedback. We will investigate the possibility of implementing this feature.
Re: Create index
Hi. Any news about Index? Why vote if Devart do not apply users voice ?
Re: Create index
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.
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.