How I used select query string and insert query in ASP.NET MVC 4

Question

0.00/5 (No votes)

See more:

i want small example to display data in table using query string not using lambda or linq .

What I have tried:

i want example to learn how i used query string in mvc4

Posted 4-Apr-16 20:54pm

Member 12244977

Updated 4-Apr-16 21:16pm

Add a Solution

1 solution

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)

princektd · Answer 1 · 2016-04-04T21:16:00

Solution 1

If you mean a raw sql query, you can do something like this:

C#

using (var context = new MyContext()) 
{ 
    var items = context.Database.SqlQuery("SELECT * FROM dbo.MyTable").ToList(); 
}

You can check MSDN for examples on executing raw sql queries.

Posted 4-Apr-16 21:16pm

princektd

Comments

Member 12244977 5-Apr-16 7:32am

can you tell me how i insert please or told me about link or site i can learn from it and thanks .

princektd 5-Apr-16 21:14pm

Usually, the entity framework in MVC4 is used along with LINQ.That is the norm. However, Entity Framework does allow execution of raw queries for special circumstances, for example, if the query has to be generated dynamically or so. Of course, you can do the same with LINQ also. But anyway, the point is that you can execute raw queries.

Check these links for examples:
1) BinaryIntellect Knowledge Base: http://www.binaryintellect.net/articles/fbc96859-8a31-4735-baeb-7adcbc521b30.aspx
2) StackOverflow: http://stackoverflow.com/questions/16828974/how-to-execute-raw-sql-query-with-in-entity-framework