Solved

Help with the Entity Framework in VB for Web app

Posted on 2009-05-07
3
355 Views
Last Modified: 2013-12-25
I am starting a big Web base project and would love to use the Entity Framework. The problem is that I can't seem to find the examples I need. We only use Stored Procedures in our Web applications. And I did fine on the web how to Data Bind a grid using a SP and the Entity Framework:

Dim sp As New NorthwindEntities

Me.GridView1.DataSource = sp.usp_emp_GetAll

Me.GridView1.DataBind()


I also found this on the net:

Dim oDam As emp = (From o In sp.usp_emp_GetAll).FirstOrDefault

Dim sString As String

Dim iEmpNo As Integer

If Not oDam.deptReference.IsLoaded Then oDam.deptReference.Load()

iEmpNo = oDam.empno

sString = oDam.dept.deptno


But unfortunately that is all I can find for The Entity Framework for VB and Web Application and SQL 2000.
What I need to know is how do I use parameters with the Stored Procedure examples I gave above. (Including OUTPUT Parameters)

I get how to do the Insert, Update and Deletes with Stored Procedure.
But how do you get your results into some kind of Data Reader or Data Set so I can go in and manipulate the data? How do I iterate through the data if I return multiple rows of data?

And one last thing. If I have Visual Studio 2008 SP1 and .Net Framework 3.5 SP1 Do I have the Latest Greatest of the Entity Framework?

I hope I am not asking for too much; but it would be great if I could get some code examples like the ones I showed above, on how to do the things I asked about?  If you could I would be internally grateful.

Thanks
Matt
 
0
Comment
Question by:mutlyp
  • 2
3 Comments
 
LVL 69

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 24327839
if you are serious about EF, I strongly suggest that you get Julie Lerman's book on the subject. Chapter 6 is dedicated to that topic. Have a look at http://learnentityframework.com/LearnEntityFramework/
0
 

Author Comment

by:mutlyp
ID: 24328840
Thanks I have ordered the book.
But I would still like my question answered if possible.
Thanks
0
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 24329025
I have only completed the first 3 chapters. I am not of big help right now!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
This video teaches users how to migrate an existing Wordpress website to a new domain.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now