Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. LINQ
  4. linq to sql

linq to sql

Scheduled Pinned Locked Moved LINQ
csharpdatabasevisual-studiolinqhelp
8 Posts 4 Posters 13 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    saharmirzaei
    wrote on last edited by
    #1

    i have a database i made it by sql server2012,in this database i have many store procedures and many views i wanna write an application by C# visual studio 2012,i dont know how i should use these store procedure and views by linq.i dont know these codes.would u help me?

    U D 2 Replies Last reply
    0
    • S saharmirzaei

      i have a database i made it by sql server2012,in this database i have many store procedures and many views i wanna write an application by C# visual studio 2012,i dont know how i should use these store procedure and views by linq.i dont know these codes.would u help me?

      U Offline
      U Offline
      uspatel
      wrote on last edited by
      #2

      you can generate edmx file that maps your database objects into Entities. http://msdn.microsoft.com/en-us/library/vstudio/cc716703(v=vs.100).aspx[^] then you can query LINQ to Entities http://msdn.microsoft.com/en-us/library/vstudio/bb399367(v=vs.100).aspx[^]

      Thanks


      Blog |Articles|Answers

      S 2 Replies Last reply
      0
      • U uspatel

        you can generate edmx file that maps your database objects into Entities. http://msdn.microsoft.com/en-us/library/vstudio/cc716703(v=vs.100).aspx[^] then you can query LINQ to Entities http://msdn.microsoft.com/en-us/library/vstudio/bb399367(v=vs.100).aspx[^]

        Thanks


        Blog |Articles|Answers

        S Offline
        S Offline
        saharmirzaei
        wrote on last edited by
        #3

        This code is written for the console application. Can I use this code in windowsform application would I use?

        U P 2 Replies Last reply
        0
        • U uspatel

          you can generate edmx file that maps your database objects into Entities. http://msdn.microsoft.com/en-us/library/vstudio/cc716703(v=vs.100).aspx[^] then you can query LINQ to Entities http://msdn.microsoft.com/en-us/library/vstudio/bb399367(v=vs.100).aspx[^]

          Thanks


          Blog |Articles|Answers

          S Offline
          S Offline
          saharmirzaei
          wrote on last edited by
          #4

          how can i use from my store procedure or views by these codes?

          U 1 Reply Last reply
          0
          • S saharmirzaei

            This code is written for the console application. Can I use this code in windowsform application would I use?

            U Offline
            U Offline
            uspatel
            wrote on last edited by
            #5

            yes.

            Thanks


            Blog |Articles|Answers

            1 Reply Last reply
            0
            • S saharmirzaei

              how can i use from my store procedure or views by these codes?

              U Offline
              U Offline
              uspatel
              wrote on last edited by
              #6

              There are lot of material available on google try https://www.google.co.in/webhp?q=use%20stored%20procedure%20in%20entity%20framework[^] http://msdn.microsoft.com/en-us/data/gg699321.aspx[^]

              Thanks


              Blog |Articles|Answers

              1 Reply Last reply
              0
              • S saharmirzaei

                This code is written for the console application. Can I use this code in windowsform application would I use?

                P Offline
                P Offline
                prajapati mukundbhai
                wrote on last edited by
                #7

                :) ;) http://dj9okeyxktdvd.cloudfront.net/script/Forums/Imhttp://dj9okeyxktdvd.cloudfront.net/script/Forums/Images/smiley\_frown.gifages/smiley\_wink.gifhttp://dj9okeyxktdvd.cloudfront.net/script/Forums/Images/smiley\_cry.gif

                1 Reply Last reply
                0
                • S saharmirzaei

                  i have a database i made it by sql server2012,in this database i have many store procedures and many views i wanna write an application by C# visual studio 2012,i dont know how i should use these store procedure and views by linq.i dont know these codes.would u help me?

                  D Offline
                  D Offline
                  deepankarbhatnagar
                  wrote on last edited by
                  #8

                  Hi, through this link which contains code as well as data to explain. hope this will help. Simple LINQ to SQL in C#[^]

                  hi

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • World
                  • Users
                  • Groups