How to we use dynamic queries in EDMX files i.e. Enterprise library

Question

0.00/5 (No votes)

See more:

, +

In my one of the project I am not having control over database because it is managed by client. We are supposed to create UI to show values from DB. In some stored procedures user is returning data through Dynamic SQL Query. Now we are finding issue in creating edmx objects in Entity Framework for these procs. Guys please help here.

Technology : ASP.Net MVC, Entity Framework 5, MS-SQL Server

What I have tried:

We tried using ADO.Net but we want to call the same through enterprise library. It would be definitely handled by Microsoft.

Posted 27-Mar-19 3:44am

Member 14199527

Updated 27-Mar-19 6:31am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vincent Maverick Durano · Answer 1 · 2019-03-27T06:32:00

Seems like you would want to build an IQueryable<T>. Search on Dynamic Query Expression on EF to get more information. Here's one example that may help you get started: Dynamic Query Expressions With Entity Framework | Code with the wind[^]

If you are expecting a different set of results then you can use IEnumerable<dynamic> to return anonymous object based from row sql dynamic query.

Also, if you want to take advantage of the new features of EF including full support of storedprocedures then you want to look at EF 6 instead: Entity Framework Code First and Stored Procedures[^]

#realJSOP · Answer 2 · 2019-03-27T04:25:00

The easiest way - setup your own database, import the data into it (using the customer's stored procedures to acquire the data), and then write EF models to load it from YOUR database.

EF will NOT be able to properly define models from datasets *returned by stored procs* that are selected from temp tables, or (it appears) dynamic sql. If you're using EF6 or earlier, don't hold your breath waiting for a fix from MS. They're not at all interested in maintaining anything older than EF7 (.Net Core).

How to we use dynamic queries in EDMX files i.e. Enterprise library

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0