Solved

Help with the Entity Framework in VB for Web app

Posted on 2009-05-07
3
354 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
Comment Utility
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
Comment Utility
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
Comment Utility
I have only completed the first 3 chapters. I am not of big help right now!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

743 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

16 Experts available now in Live!

Get 1:1 Help Now