Launching my first business app?

I am starting work on my first business application (application + database) using C # and sql. I'm completely new to this,

What advice do you have for me?

What should I look for?

What concepts should I understand?

+4
source share
5 answers

While your question is broad, here is the first thing I “wanted to know” when I started working with business applications, but was pretty universal:

Writing business applications is greatly simplified by creating a reliable DAL (level of data access) and abstracting access to data from the rest of your application. Thus, all of your SQL is in one place and not scattered throughout your code.

Some golden ideas for reading in this area are “ORM” (object-relational mapping, since you are using C #, Linq to SQL can be a good place to start) - this maps the database access to the actual classes, If you have a good database design, you may even find that you have very little SQL work.

Another good practice is to use a repository template that effectively encapsulates all data access in one class (at least in the simple case - of course, in large applications that may have several). Then, to access any data, you always go through the repository. This is usually done through an interface that defines the repository, which then allows you to implement several specific implementations. For example, you might want to get your data directly from a SQL server, but later or in an alternative application you can use a web service to retrieve the data instead - you don’t need to rewrite everything, just run a new repository class! The interface remains the same, so the rest of your application knows nothing else: D)

This is a fairly extensive review (and a little bend of the mind), and I'm certainly not an expert, but believe me, good data access methods will certainly make your life easier!

+3
source

My advice is to start and come back when you have a specific question. If this makes you feel more prepared, first read a few more C # and SQL books.

+6
source

Just start writing code. After that, you will have to throw it away when you find out what happens, but that’s good.

+2
source

Well, I would say that you came to the right site if you asked specific questions.

Some of our top rated questions, however, will give you tons and tons of reading material, books, links to other sites, etc. Here is the url

https://stackoverflow.com/questions?sort=votes

+1
source

General tips:

  • Get some help from someone who has done this before. You will not be able to do it yourself if you do not take a lot of time to study at work.
  • Do not get distracted by technical details - make sure you understand the business . If you don’t know why you are creating the application (or your customers don’t know why he needs it), it cannot be good.

How much you should look for or how much you need to understand, I do not know the scope of the application you are trying to build, so I can not give reasonable advice. The real-time financial system used by thousands of concurrent users is different from a small retail site that hits hundreds. Therefore, my only look at / understanding the advice is this: do not overestimate your decision.

+1
source

All Articles