It would be nice to be able to generate SQL script from the model for multiple databases. Currently it is possible to replace the models connection, but having the option of choosing a target "dbms type" upon generation would allow us to discard external modelling tools.
The ideal solution would contain multiple relational models to control type mappings etc, but it would probably suffice with an option as described above.4 votes
it would be nice if we can update only ONE entity from database.
a right-click menu option "update this entity from database" on entity would be perfect solution.
currently, is is pretty painful to do so, since we have to start from all objects and un-check everything except the entity that we are interested in.
thank you4 votes
Give user ability to add his own custom code to both mapping and class files which is preserved through "custom code region"
// -- Begin custom code region --
// -- End custom code region --3 votes
EntityDeveloper has its own nuances. A better track of documentation and training material will be of great help for new comers.
Tutorials Printed & Video, Sample Projects & Walkthroughs become invaluable time savers.3 votes
Generate interfaces for purposes of testing.3 votes
Linq to SQL. in case of huge database it is very difficult to work with stored procedures mishmash, when the package logical grouping is lost. In simple way it has the workaround with package name prefix.3 votes
I would like to be able to convert my database objects, which are in underscore notation into PascalCase when I do database-first work. Likewise, I would like to convert my PascalCase .NET objects into underscore notation in the database when doing model-first. So
MY_GREAT_TABLE becomes MyGreatTable and, MyGreatClass would become MY_GREAT_CLASS.3 votes
First of all, thanks for your great work ! Your Castle Active Record template is excellent.
It would solve a very common problem if you could add another template which generates classes that do not inherit from ActiveRecordBase (see http://www.castleproject.org/activerecord/documentation/trunk/advanced/mediator.html).
That should create <ClassName>.cs with attribute-decorated properties and optionally another, <ClassName>Repository.cs3 votes
Add the ability to generate an enum based on the actual data from a table and have it automatically assign the value of each item based on the primary key of each particular row. Automatically assign the best base type for the enum based on the total number of rows of data its being generated from.
Also it would be nice if this was two-way. One could also "deploy" the data from one or more enums back into the database as rows of data.3 votes
Since we can connect to Oracle without using a TNSNAMES.ORA by fully specifing de DSN entry I think the connection interface should manage this by itself.
An example of a DSN-less connectionstring:
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;3 votes
When creating a model via Database First, the Stored Procedure Mappings for the CRUD operations should be created automatically. There should be some configurable logic like "for a table Customer there are stored procedures InsertCustomer, UpdateCustomer, DeleteCustomer".
Some more details can be found here: http://forums.devart.com/viewtopic.php?f=32&t=284613 votes
Having the posibility to Enter "normal" SQL Code and out of this, generate the right LinQ Code.3 votes
please support a dark theme as in VS2012 in the standalone version of entity developer3 votes
Support for the EF4 CTP about the code first development. See http://blogs.msdn.com/b/efdesign/archive/2010/06/21/productivity-improvements-for-the-entity-framework.aspx3 votes
This should then create a unique constraint for the corresponding column in SQL.
Often there are fields that are not primary key, but still need to be unique "natural part numbers" are a common example.2 votes
Support view pregeneration in the DbContext template when generating fluent mapping.1 vote
After creating a Entity Model based on SQL Server 2008, I have to change the connection string so that queries run correctly.
I have to add...
If would be nice if the Entity Developer would have this set by default just like the VS 2010 EDM designer.
Also, It would be nice to be able to modify the connection properties using the "Edit Model Setting" screen instead of having to edit the string manually in the .edps code file.1 vote
My company uses a standard naming convention for private variables in classes which is different to the format produced by your product. It appears one cannot change this format from the layout eg '_MyPrivateVariable' to 'myPrivateVariable'. We use camel case for private variable declarations. I notice that there isn't an option for camel case at all. My recourse at the moment is to hand edit all the class files or develop a script to do this.1 vote
Allow column&props to be added as a pair auto-mapping bit>boolean, char>string via default map table
When adding a column, to be able to auto-add a property (via tick box) that maps to it and uses a default but alterable type mapping table.
E.g. Char becomes String, etc.
If nullable then IS nullable.0 votes
- Don't see your idea?