dotConnect for Oracle Documentation
In This Topic
    Query Options
    In This Topic

    dotConnect for Oracle has some options that customize translating LINQ to Entities to SQL statements. The list of these options includes:

    Please note that the last two options work with both common DefaultValue SSDL attribute and the new custom devart:DefaultValue SSDL attribute. The latter attribute does not trigger the type consistency check, so you can use a wider range of default values, like CURRENT_TIMESTAMP or my_sequence.nextval.

    Here is a simple example:

    <Property Name="ProductID" Type="int" Nullable="false" 
    devart:DefaultValue="my_sequence.NEXTVAL" StoreGeneratedPattern="Identity" />

    The generated SQL command looks like the following:

    INSERT INTO "Product"
      ("ProductID","ProductName","UnitScale","InStock","Price","DiscontinuedPrice")
      VALUES(my_sequence.NEXTVAL,:p0,:p1,:p2,:p3,:p4)

    These options can be set either in code as the properties of the EntityProviderConfig.QueryOptions object or in the project config file as the attributes of the QueryOptions element of the Devart.Data.Oracle.Entity tag.