Solved

Help with the Entity Framework in VB for Web app

Posted on 2009-05-07
3
359 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 70

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 70

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

Percona Monitoring and Management and Grafana

Proactive monitoring is vital to a highly-available environment. We have a quick start guide on Experts Exchange for Grafana users.

Question has a verified solution.

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

When the s#!t hits the fan, you don’t have time to look up who’s on call, draft emails, call collaborators, or send text messages. An instant chat window is definitely the way to go, especially one like HipChat. HipChat is a true business app. An…
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
The viewer will learn how to count occurrences of each item in an array.

632 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