You must Sign In to post a response.
  • Category: ASP.NET

    Fetching data from DB using EDMX in asp.net C#

    Hi All,

    We have connected to sql through EDMX.

    I want to fetch the data from DB (1table) using EDMX and display it on front end..

    i want output like this
    DB -- 1 table and multiple rows
    example -- rows in db - treaty_uwy, treaty, treaty_old,treaty_month

    front end - same number of columns
    uwy Treaty treatyold treatymonth
    2001 23 12 10
    2015 244 234 09
    ...
  • #767465
    Hi,
    You can use following approaches for quering in Entity Framework:
    1. LINQ to Entities
    2. Entity SQL
    3. Native SQL
    Please find demo source code over here:
    http://www.entityframeworktutorial.net/Querying-with-EDM.aspx
    https://msdn.microsoft.com/en-in/data/jj206878.aspx


Sign In to post your comments