My dip into C# and .Net Framework

Jennifer Wong
Aug 27, 2017 · 3 min read

I started learning C# and the .Net Framework through a company’s online learning platform. I started a project and am currently in the 6th dive of the project. It is interesting since I needed both Visual Studio and SQL Server Management Studio(SSMS) on a Microsoft computer. I did a lot of debugging which helped me figure out the flow of data through the existing C# code in Visual Studio. I also created the schema for the second table in SSMS using the window design and didn’t have to write it in T-SQL.

There was an issue that I ran into and was googling to find a way to fix it. The SSMS doesn’t allow the user to ALTER the table once it is created since it requires SSMS to DROP and CREATE the table. The permissions doesn’t allow this change.

I was provided a remote mentor through the company’s website and asked how to get permissions to ALTER a table since through all the googling I did online. Nothing said exactly how to do it correctly. I had looked through the MSDN library and other queries on a possible solution. Nothing worked!

This is how to do it correctly:

To change the Prevent saving changes that require the table re-creation option:

  1. Open SQL Server Management Studio(SSMS)
  2. On the Tools menu, click Options
  3. In the navigation pane of the Options window, click Designers.
  4. Select or clear the Prevent saving changes that require the table re-creation checkbox, then click OK.

My second big search was how to create a dropdown list. This is a good youtube video on how to create one with window design.

I created one using the youtube video and refactored the code in order for it to fit the MVC (Model/View/Controller) design being used. The dropdown list was created in .aspx file which is the View while the main function was located in the a BLL.cs file and the sql query was located in a DAL.cs file. Both the BLL.cs and DAL.cs are part of the Controller design. The files uses CRUD (Create, Read, Update, Delete). The BLL.cs file is the Business Logic Layer, and is the instance of the Data Access Layer class. The DAL.cs is the Data Access Layer and communicates with the database.

I also created different UML diagrams. One was a model diagram and another for a sequence diagram.

The Unified Modeling Language (UML) is a general-purpose, developmental, modeling language in the field of software engineering, that is intended to provide a standard way to visualize the design of a system.

Some links for UML diagrams:

)
Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade