Global Data Management Forum

Missing Indexes after Scaffolding Dbcontext from tables on DB2 server

  • 1.  Missing Indexes after Scaffolding Dbcontext from tables on DB2 server

    Posted Mon August 31, 2020 09:05 AM
    Hi,

     Background:-
    We are trying adding DB2 database support to an application running with SQL as Database to heed the requests from some of our customers having lot of Data on DB2 server.

    Scenario:- I am using IBM.EntityFrameworkCore 3.1.0.200
     with Microsoft.EntityFrameworkCore 3.1.2.
     Able to scaffold out the Dbcontext with minor disparities that can be taken care but what I got stumbled upon is that Indexes are totally missing out of the generated Dbcontext class.


    Observation:- 
    What I noticed in Db2 is, Tablespaces are distinct for Data than that of its Indexes where as the DataFile is same for both, Data and Indexes in SQL.

    Any help, direction, advice is much appreciated! We have been banging our heads to figure out the root cause for some time now.


    Thanks & Regards,
    Utkarsh Rastogi




    NOUS INFOSYSTEMS DISCLAIMER : This e-mail transmission may contain confidential or legally privileged information that is intended only for the individual(s) or entity(ies) named in the e-mail address. If you are not the intended recipient, please reply to the postmaster@nousinfo.com, so that arrangements can be made for proper delivery, and then please delete all copies and attachments. Any disclosure, copying, distribution, or relaying upon the contents of this e-mail, by any other than the intended recipients, is strictly prohibited.

    #DataManagementGlobal
    #DataServerDrivers