Results 1 to 13 of 13
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Joe Hummel Webcastes (VB.Net)

    Christmas 2004 I happened upon Joe Hummel's lectures on using Visual Basic Net for accessing databases and on how to do object orientated programming. He is a marvellous lecturer, very easy to listen to, and points out the bits of interesting code that will catch you out. His lectures are aimed at VB6 (and before programmers.

    There are fifteen lectures of over one and a half hours in length each. I sat down and over three days watch the entire batch of fifteen lectures. At the end of this marathon I now know a bit more about VB.Net, I now know why you have object oriented programming, in fact there are lots of things I know. One of the most important things I know is that there's a bl**dy lot of stuff I don't know! However, what I have seen shows me that Visual Basic.net is not beyond my capabilities. I was correct in thinking that my Microsoft Access training has given me a very good leg up with this new language, and I am very interested to learn more.

    To this end Joe has also provided a fantastic range of lessons that accompany each lecture these can be found at his web site and downloaded onto your PC. I found that by reading his slides and following his examples I could very easily complete the exercises, well not that easy, but because I have seen all fifteen lectures I am convinced that visual basic.net is the way for me to go. I am a complete beginner with Visual Basic .net, however I have followed the fifteen lectures mentioned and done the first two "homework

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Joe Hummel Webcastes (VB.Net)

    Yes, indeed, your Access experience will stand you in good stead in VB.Net, especially if you ever worked with ADO and/or classes in VBA. I have found that my background in Access/ADO/Classes was much more useful than my lesser knowledge of VB6. We are building fairly sophisticated data tier and business tier layers in our application, and I haven't yet found any good references on that kind of programming granularity in VB.Net, but I'd love to see some if anyone else has run across them. Most of the resources and training I've encountered teach you how to use a dataadapter from the presentation tier, which isn't allowable in a true client-server, N-tier architecture.
    Charlotte

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Joe Hummel Webcastes (VB.Net)

    Hi Charlotte,
    I recall that Joe did cover using the data adapter and he provides some very nice examples of how to do this correctly. I think the code is with the lecture number ten stuff which is downloadable from his website. If you have the time I would suggest you at least look at the three lectures on databases. I don't think you will be disappointed. I found the quality of all the lectures of the highest level, and I feel privileged to have been granted access to these lectures, which the Net and Microsoft have made possible.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Joe Hummel Webcastes (VB.Net)

    Oh, I know how to use a data adapter. The point is, in an N-tier application, only the data tier programmer uses a data adapter. The UI programmer uses whatever data mechanisms have been provided by the data tier. What I'm looking for is training on building data providers, etc., in the data tier and what level of granularity to use under which circumstances. The UI programmer should never need to know about them. In fact, the UI programmer doesn't even need to know what kind of back end the application uses because the data tier programmer makes it transparent. In our apps, I'm working in all the tiers, so I have to keep my mind on one type of programming at a time to avoid using techniques not appropriate to that particular tier.
    Charlotte

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Joe Hummel Webcastes (VB.Net)

    I do recall that Joe covered the use of the data tier in great detail, and he provided classes for the purpose. I can't remember exactly where it was in the lectures. If I come across it I will post back its location. From my limited knowledge of Classes I believe Joe Covered exactly what you are looking for. At least have a look at lecture number ten, I think it's in there, but I can't be too sure. The other way of tracking it down is in the resources on Joe's web site. Joe provides a copy of the PowerPoint presentation For each lecture so you could download those and flick through to find a Reference to the classes for the data Tier.

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Joe Hummel Webcastes (VB.Net)

    One of my co-workers has modified the Microsoft SQLHelper application block to make a very powerful data-tier. This is used in conjunction with a manager-factory model. He's made my job very easy!

    All I have to do to use this is to create a class with all of the needed properties (which usually maps directly to a table), add the necessary DataFieldAttribute attributes to map the properties to the corresponding table fiels. Next, I create a manager class that contains any necessary persistence methods (Insert, Update, Get, GetList, Delete, etc) along with any business logic functionality. I simply pass the object into the desired method, or request the object from the method in the manager class without caring about what happens to do the database dirty work. (Although, granted, I do have to reference the appropriate stored procedures in the manager class methods.)

    It's a very nifty process - I'm so spoiled that I hope I never have to do any n-tier programming without this model!

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Joe Hummel Webcastes (VB.Net)

    Hi Charlotte,

    Yes! I have just checked, I'm absolutely sure that lecture ten covers exactly what you're looking for!

    if you go to Joe Hummel's website

    and download the zip file Under the link in this line:

    10 of 15 (Thur Apr 15) - Databases (part 3 of 3): data & business tier design: Lecture, Lab not yet available

    you will find a copy of the PowerPoint presentation , but most importantly there is the actual Visual Basic.Net code, a working example of exactly what you are looking for!

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Joe Hummel Webcastes (VB.Net)

    I'm not really looking for code, Rupert, but I will certainly take a look at the material. I was actually looking for more theory and logic of designing the granularity of the data tier, not code.
    Charlotte

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Joe Hummel Webcastes (VB.Net)

    The UI programmer just has to use the manager classes. I have to also build them. We're still refining the logic and developing our approach in a vertical slice of the future application, so theory is what I'm looking for. My books and CBT training all explain how to do various things. I haven't found anything with a good explanation of *why* you would slice up the logic in a particular way into particular classes in particular tiers. That's what I'm really looking for. I pretty much know how, but I'd like to examine someone else's thoughts on why this way rather than that way. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    Charlotte

  10. #10
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Joe Hummel Webcastes (VB.Net)

    Hi Charlotte,

    You may have already seen this, but I've found a lot of good information directly from the horse's mouth, er... Microsoft, that is. The Patterns and Practices section of their site has lots of good information, particularly the Enterprise Solution Patterns resource. You may also check the Architecture site on MSDN.

    Even if you've already exhausted these resources, hopefully others will find the links helpful!


    Edit: I just discovered a page that deals specifically with the data tier: Designing Data Tier Components and Passing Data Through Tiers. This sounds like it's what you're looking for.

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Joe Hummel Webcastes (VB.Net)

    Oooh, that looks good! Thanks for the link. I'll study it. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    Charlotte

  12. #12
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Joe Hummel Webcastes (VB.Net)

    >>>>> I haven't found anything with a good explanation of *why* you would slice up the logic in a particular way into particular classes in particular tiers<<<<

    On Slide 3 lecture 10 Joe Hummel, PhD says:

    Quote:
    For most business applications, the heart of the design revolves around the data and business tiers. There is no right design, only trade-offs

  13. #13
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Joe Hummel Webcastes (VB.Net)

    Yes, Rupert, and that is true of all programming, not just n-tier in .Net.
    Charlotte

Posting Permissions

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