Results 1 to 4 of 4

Thread: VB.NET Core projects/Entity Framework Core

  1. #1

    Thread Starter
    Karen Payne MVP kareninstructor's Avatar
    Join Date
    Jun 2008
    Location
    Oregon
    Posts
    6,684

    VB.NET Core projects/Entity Framework Core

    Entity Framework is not for everyone while it seems that for reverse engineering an existing database VB.NET takes a backseat to C# where there are Visual Studio extensions (like EF Power Tools) and T4 templates to reverse engineer databases.

    So I've started a GitHub repository for teaching how to use Entity Framework Core with VB.NET in .NET Core projects. Currently just writing code but will have an article out by the end of December.

    The article will have walkthroughs on how to created necessary classes for basic operations one would expect in an application with focus more on the backend rather than the frontend. Also using appsettings.json with a generic reader.

    If interested here is the repository.

    Requires Visual Studio 2019 and SQL-Server (Express edition is fine). To run the code, clone the repository, perform a NuGet restore packages and run the SQL script to create a modified version of Microsoft NorthWind database.

  2. #2
    Angel of Code Niya's Avatar
    Join Date
    Nov 2011
    Posts
    8,598

    Re: VB.NET Core projects/Entity Framework Core

    I tried to learn Entity Framework once, and while I was impressed with what it can do, I ran into it's limits very quickly. It's been years so I can't remember the details but I recall it being very difficult to do anything but very simple updates. When you start having complex update requirements, it was a nightmare to get EF to do it. What I mean by complex updates is the type of updates where you're updating multiple tables, many times with inputs from both the client and data in other tables and sometimes you want to do it all within a transaction. I also recall it being unable to work with certain database structures, especially ones with a lot of PK-FK links. Like I said, I don't remember details but I do remember it giving me a very hard time.

    I gave up eventually and went back to doing things the old fashion way. But I've always loved the potential of the technology. I'd definitely like to check out EF again one day. See where it's at today. It's also possible that my failure with it was due to a lack of understanding.
    Last edited by Niya; Dec 12th, 2020 at 12:27 PM.
    Treeview with NodeAdded/NodesRemoved events | BlinkLabel control | Calculate Permutations | Object Enums | ComboBox with centered items | .Net Internals article(not mine) | Wizard Control | Understanding Multi-Threading | Simple file compression | Demon Arena

    Copy/move files using Windows Shell | I'm not wanted

    C++ programmers will dismiss you as a cretinous simpleton for your inability to keep track of pointers chained 6 levels deep and Java programmers will pillory you for buying into the evils of Microsoft. Meanwhile C# programmers will get paid just a little bit more than you for writing exactly the same code and VB6 programmers will continue to whitter on about "footprints". - FunkyDexter

    There's just no reason to use garbage like InputBox. - jmcilhinney

    The threads I start are Niya and Olaf free zones. No arguing about the benefits of VB6 over .NET here please. Happiness must reign. - yereverluvinuncleber

  3. #3
    PowerPoster PlausiblyDamp's Avatar
    Join Date
    Dec 2016
    Location
    Pontypool, Wales
    Posts
    2,458

    Re: VB.NET Core projects/Entity Framework Core

    Quote Originally Posted by Niya View Post
    I tried to learn Entity Framework once, and while I was impressed with what it can do, I ran into it's limits very quickly. It's been years so I can't remember the details but I recall it being very difficult to do anything but very simple updates. When you start having complex update requirements, it was a nightmare to get EF to do it. What I mean by complex updates is the type of updates where you're updating multiple tables, many times with inputs from both the client and data in other tables.

    I gave up eventually and went back to doing things the old fashion way. But I've always loved the potential of the technology. I'd definitely like to check out EF again one day. See where it's at today.
    If I am doing anything "serious" with data access I would tend to still go with EF, I really like the querying side of things, and not having to deal with DataSets or populate my own data objects saves a lot of effort. Any complex queries or updates I would use views / stored procs but still access them via EF.

  4. #4
    Angel of Code Niya's Avatar
    Join Date
    Nov 2011
    Posts
    8,598

    Re: VB.NET Core projects/Entity Framework Core

    Quote Originally Posted by PlausiblyDamp View Post
    If I am doing anything "serious" with data access I would tend to still go with EF, I really like the querying side of things, and not having to deal with DataSets or populate my own data objects saves a lot of effort.
    This is exactly what drew me to EF in the first place. I absolutely loved that aspect of it. It felt so incredible to be able to use normal objects to manipulate the database. But as I went along with it, I found myself asking more and more how to do this or that and not getting the information I needed. It reached the point where I had way more questions than answers and it just wasn't worth the headache for me anymore.

    Quote Originally Posted by PlausiblyDamp View Post
    Any complex queries or updates I would use views / stored procs but still access them via EF.
    I thought about that as well but I decided against it. Can't remember the reason why though. I have a next CRUD project coming up and before I start it, I think I'll revisit EF and give it another shot.
    Treeview with NodeAdded/NodesRemoved events | BlinkLabel control | Calculate Permutations | Object Enums | ComboBox with centered items | .Net Internals article(not mine) | Wizard Control | Understanding Multi-Threading | Simple file compression | Demon Arena

    Copy/move files using Windows Shell | I'm not wanted

    C++ programmers will dismiss you as a cretinous simpleton for your inability to keep track of pointers chained 6 levels deep and Java programmers will pillory you for buying into the evils of Microsoft. Meanwhile C# programmers will get paid just a little bit more than you for writing exactly the same code and VB6 programmers will continue to whitter on about "footprints". - FunkyDexter

    There's just no reason to use garbage like InputBox. - jmcilhinney

    The threads I start are Niya and Olaf free zones. No arguing about the benefits of VB6 over .NET here please. Happiness must reign. - yereverluvinuncleber

Tags for this Thread

Posting Permissions

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



Click Here to Expand Forum to Full Width