How can we improve Microsoft Azure SQL Data Warehouse ?

Support for Entity Framework

Support for Entity Framework in Azure SQL Data Warehouse would allow for greater usability in general, but it would also allow for better support of other frameworks/protocols. Specifically, we have a need to serve our data through an OData feed, and Entity Framework's deferred execution would allow us to handle OData's Query Options in a much simpler way.

121 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Logan McLain shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    10 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Srini commented  ·   ·  Flag as inappropriate

        When are we expecting to support EF on azure Sql server database house.

      • Karl commented  ·   ·  Flag as inappropriate

        Just got caught out by this one as well - seems to be a fairly basic failing to not support code first schema management tooling

      • Trestin Bradley commented  ·   ·  Flag as inappropriate

        moved a large historical db over to a warehouse. it would be nice to just change the connection instead of having to jump through hoops to query the data from the new source.

      • chris smith commented  ·   ·  Flag as inappropriate

        Yes I have the exact same need - would like to spin up an ODATA Web API which relies on Entity Framework and want to lay this web service over SQL Data Warehouse.

      • Alex Randall commented  ·   ·  Flag as inappropriate

        Scenarios:

        - C# code First (automatic table definition/creation/ and database migrations support/schema upgrade inside Azure SQL Data Warehouse)

        - loading data into Azure SQL Data Warehouse directly using C# Linq insert statements with entity framework sending appropriate sql behind the scenes for automatic statistics recompute,

        - updating/delete data from Azure SQL Data Warehouse directly # Linq insert statements with entity framework sending appropriate sql behind the scenes for automatic statistics recompute

        - both for .net core version of entity framework as well as .net 4.5+

      • Anonymous commented  ·   ·  Flag as inappropriate

        same here, we have lots of existing code based on EF. Moving to Azure SQL Data Warehouse without EF support is not an option for us right now.

      Feedback and Knowledge Base