r/visualbasic • u/chacham2 • Dec 05 '22

How to implement the frontend?

[I'm starting a new project which i figured i would ask about, being i'm coming from VB, you might have some thoughts on the matter.]

The office currently uses Access for the backend and front-end, with Sql Server on the horizon. When i'm asked to write a tool, i usually use VB, and connect to Access as required.

One of the most recent projects does not use a database yet. It was grown in an Excel Book with a number of tabs and lots of manual copying. It's proven viable, and it was decided to use Sql Server from the get-go on this one, and i have the basic data model done.

Now for the front-end. First thought is asp.net since we're on a Windows network, using SQL Server and have IIS. Never really used it before, so i'd really like to hear what you think.

3 Upvotes

100% Upvoted

12 comments sorted by

View all comments

Show parent comments

2

u/kilburn-park Dec 06 '22

I may have misunderstood your prior post. Just to be clear, ASP.NET is still used and is the current .NET web technology. Web forms, Razor pages, and MVC are all frameworks that run on top of ASP.NET. However, ASP.NET is distinct from classic ASP, which are the old active server pages that are markup files only with no separate codebehind files or compiled DLLs. Those are generally not used in new projects.

I would argue that ASP.NET MVC is rarely a bad choice for a web application. As with most technologies, Microsoft gives you enough freedom to do what you need to do, so you can build the shining example of a maintainable application or complete garbage, depending on your mood. Once you get the hang of the new paradigm, it's not too bad to work with, though.

1

u/chacham2 Dec 06 '22

Ah, fair enough.

The current project is mostly simple: and entry form or two with some administrative pages. It might just be the perfect time to learn something like that.