19 results found

1. Keep "Store Generated Pattern" saved when updating model.

   When "Create from database" option is used - the Store Generated Pattern values i.e. "Identity" are lost. Those values should be remembered for tables that didn't change. Now user has to set each value manually after update.

   57 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  5 comments  ·  Delete…  ·  Admin →

2. Batch Updates

   Performing INSERT/UPDATE/DELETE operations in batches will increase performance of data updating.

   39 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  3 comments  ·  Delete…  ·  Admin →

3. Support case-insensitive and accent-insensitive text operations, for ex. Contains

   Currently case-insensitive text operations for ex. with Contains is not supported.

   This is useful in the scenario of a search feature, when we have to find a person by name. The name can contain upper-lower case and accentuated characters that must be handled as a simple character.

   At the moment, only a workaround is possible, by executing Oracle-specific commands.

   37 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  4 comments  ·  Delete…  ·  Admin →

4. Support for Oracle regex commands

   Add support for Oracle functions like REGEXPLIKE, REGEXPSUBSTR. That way, we can send regex expressions directly to the database.

   37 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  1 comment  ·  Delete…  ·  Admin →

5. SDO_GEOMETRY data type support
   35 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  2 comments  ·  Delete…  ·  Admin →

6. Oracle Hints Support in LINQ to Entities
   34 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  2 comments  ·  Delete…  ·  Admin →

7. EDM Wizard for Oracle - NUMBER mapping customization with NumberMappings

   Make EDM Wizard process NUMBER columns according to NumberMappings in the connection string.

   29 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  1 comment  ·  Delete…  ·  Admin →

8. <ProviderName>EntityProviderConfig via app.config

   Implement functionality <ProviderName>EntityProviderConfig in Oracle, MySQL, PostgreSQL, and SQLite via *.config file of your application. Currently it can be done only in code: http://www.devart.com/blogs/dotconnect/index.php/new-features-of-entity-framework-support-in-dotconnect-providers.html .

   21 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  0 comments  ·  Delete…  ·  Admin →

9. Oracle materialized view support
   16 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   completed  ·  AdminDevart (_, Devart) responded

   The support for materialized views is implemented in the 8.5.464 build of dotConnect for Oracle.

10. Configurable like implementation of Postgres

    We are using dotConnect for PostgreSQL and are using dynamic linq to entities queries. We want to do case insensitive searching on fields (without having to lowercase the field and the value to compare with).

    Since we are using dynamic linq it is not possible to use the scalar-valued ILike functionality added in the last version of dotConnect for PostgreSQL.

    To resolve our problem we would like the option to select which 'Like' statement is used by dotConnect for PostgreSQL in converting contains statements. Currently it uses (the case sensitive) Like function, we would like to be able to set this to the (case insensitive) ILike function.

    We are using dotConnect for PostgreSQL and are using dynamic linq to entities queries. We want to do case insensitive searching on fields (without having to lowercase the field and the value to compare with).

    Since we are using dynamic linq it is not possible to use the scalar-valued ILike functionality added in the last version of dotConnect for PostgreSQL.

    To resolve our problem we would like the option to select which 'Like' statement is used by dotConnect for PostgreSQL in converting contains statements. Currently it uses (the case sensitive) Like function, we would like to be able to set… more

    15 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Delete…  ·  Admin →

11. Correct Generation of SQL for SELECT Statement with NULL Parameter

    Implement a workaround for Entity Framework bug
    ( http://stackoverflow.com/questions/682429/how-can-i-query-for-null-values-in-entity-framework )
    so that users don't need to write a more complex LINQ to Entities query to avoid this bug.

    15 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Delete…  ·  Admin →

12. Support for Oracle Database Links with StoreGeneratedPattern

    If you use Entity Framework and the StoreGeneratedPattern for ROWID, ORA_ROWSCN or any other fields (no primary key fields), there is a problem if you have tables available over a database link. This can be done by creating a synonym that points to a table on another oracle database (@dblink).

    Devart creates a returning clause for getting values back, but this is not a supported feature with database links and leads into an ora-22816.

    Is it possible to implement an option in Devart so that such columns are always read back over a select statement instead of a returning clause? This is not as fast as the returning clause but can help in such a situation.

    The select statement should use the key fields (Entity Framework) to get these values back and the key fields must not have the StoreGeneratedPattern property set to get that work.

    Example Table:

    create table testtable
    (
    id number primary key,
    calculated number,
    text varchar2(1000)
    )

    StoreGeneratedPattern Settings:
    Id - None
    Calculated - Computed
    Text - None

    Example PL/SQL:

    BEGIN

    Insert into testable(id, calculated, text) values (:ID, :CALCULATED, :TEXT);

    Select calculated into :OutParameter from testable where id = :ID;

    END;

    If you use Entity Framework and the StoreGeneratedPattern for ROWID, ORA_ROWSCN or any other fields (no primary key fields), there is a problem if you have tables available over a database link. This can be done by creating a synonym that points to a table on another oracle database (@dblink).

    Devart creates a returning clause for getting values back, but this is not a supported feature with database links and leads into an ora-22816.

    Is it possible to implement an option in Devart so that such columns are always read back over a select statement instead of a returning clause?… more

    15 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  5 comments  ·  Delete…  ·  Admin →

13. "Like" SQL clause support in LINQ to Entities for Oracle

    "Like" implementation as an OracleFunctions class method.

    14 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Delete…  ·  Admin →

14. EF Code First: Database/Schema Creating and Deleting for MySQL and PostgreSQL

    Database/Schema Creating and Deleting for MySQL and PostgreSQL

    13 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Delete…  ·  Admin →

15. Code First Database Evolution / Database (Schema) Migration

    Capability to synchronize the database (schema) structure with the model structure by altering the existing database (schema) without deleting and re-creating it if possible. The changes will either be applied immediately, or the synchronization script will be generated.

    10 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Delete…  ·  Admin →

16. Text Indexing Support - CONTAINS, CTXCAT

    I would like to see the CONTAINS and CTXCAT
    funtions in the OracleFunctions class. For example:

    var result = from x in ents.MyTable
    where OracleFunctions.Contains(ctxtextcol, 'test WITHIN TITLE OR test WITHIN NAME') > 0
    select x;

    This would pretty much remove any requirements I have for writing plain old SQL.

    9 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Delete…  ·  Admin →

17. Don't Insert NULL Values on INSERT

    Make NULL insertion generation in INSERT statements optional.

    7 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Delete…  ·  Admin →

18. Shorter SQL

    Possibility to generate shorter SQL statements - without line breaks, indents, and formatting. Query formatting is useful only when monitoring SQL statements, and it increases SQL size.

    6 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Delete…  ·  Admin →

19. EF Code First: Deleting Oracle Schema Objects
    4 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Delete…  ·  Admin →