Results 1 to 5 of 5

Thread: SP and MVc

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2007
    Location
    Karachi
    Posts
    551

    SP and MVc

    Can any one suggest me to access db from MVC WITHOUT Entity framework..I need tutorial ..
    There is no achievement without goals

  2. #2
    PowerPoster kfcSmitty's Avatar
    Join Date
    May 2005
    Posts
    2,248

    Re: SP and MVc

    Which language are you using? C#/VB? And which database are you attempting to access?

    If it is MS SQL, you can use an SqlConnection (https://msdn.microsoft.com/en-us/lib....sqlconnection) to open a connection and SqlCommand(https://msdn.microsoft.com/en-us/lib...ent.sqlcommand) to run a query against the database.

  3. #3
    Junior Member valleteclark12's Avatar
    Join Date
    Mar 2015
    Location
    Best Cordless Drill & Tool Kit Buying Guide
    Posts
    16

    Re: SP and MVc

    Quote Originally Posted by ERUM View Post
    Can any one suggest me to access db from MVC WITHOUT Entity framework..I need tutorial ..
    Are you a student?
    If you dont want Entity framework, you can user LINQ,and model 3layer....

  4. #4
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    7,900

    Re: SP and MVc

    If it is MS SQL, you can use an SqlConnection
    Further to that, regardless of what DB it is there will almost certainly be some sort of ado.net suite that supports it. Pay a visit to our database forum and check out the stickies. They contain (among other things) some really good tutorials no how to communicate with databases using ADO. The examples don't use MVC but they're applicable.
    The best argument against democracy is a five minute conversation with the average voter - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd

  5. #5

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2007
    Location
    Karachi
    Posts
    551

    Re: SP and MVc

    HOLD down please !! Let me be specific about my question !!


    Accessing data in MVC can be done by following ways !! RIGHT ?????? (correct me if i m wrong )

    - LINQ to SQL
    - Entity Framework
    - NHibernate
    - other ORM
    - Straight ADO.NET

    I want to Access db from MVC4 by Straight ADO.NET .. no LINQ syntax..so the gist of whole discussion is that EF through LINQ is overhead to the project /Application ..so i want to keep away from my self from these ..and wanted to approach sample application which access sp via ado.net objects ..but surprisingly what ever articles i found on net is some how connected with LINQ ..
    There is no achievement without goals

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width