[Gibberish code pitfall series] ZJUT database large-scale experiment, pitfall zjut

[Gibberish code pitfall series] ZJUT database large-scale experiment, pitfall zjut
Student Management System (1) project establishment

1. Description

The requirements for reading textbooks should be in the C/S mode, and the Entity Framework should not be used, so the best choice is WPF. C # And WPF will be introduced later. If you want to know more, you can go to MSDN and the WPF programming book (see the latest !).

Development Environment: VS 2015 RC + SQL Server 2014. VS 2013 is also acceptable, but there is no C #6.0, and WPF should also be a little changed, but I haven't checked any of them yet. Let's look back.

 

2. Create a project

The solution has two projects: one WPF project and one library-class project, which are used to write the UI and library classes respectively. Of course, it can also be written in a project. Now, this is to facilitate management. As for the unit test, add it later. <del> I don't know when to continue writing. </del>.

First, select Visual C #, create a WPF project, change the name to EductionManagerUI, change the solution name to EducationManager, and then confirm.
　　

VS 2015 will automatically allow you to choose team management. Select Git here or click Cancel.

Right-click solution resource manager's first line, create a new project, select the Library Class, name it EducationManagerClass, and click OK. The automatically generated Class1.cs in the new project can be deleted.
　　
After the preceding settings, right-click EducationManagerUI and add a reference to EducationManagerClass to use the classes in the Library Class in the WPF project.
　　
　　
Yes!
　　

 

Next, create a database, open SSMS, and create a database named EducationManager.
　　

Then open the object Resource Manager, select Security, right-click the login name, create a login name EMAdmin, enter the password, and cancel the force password policy.

　　

Right-click the Server, select Properties and security, change Server authentication to SQL Server and Windows authentication, right-click the Server again, and choose restart.

　　

Return to VS, select a tool → connect to the database, enter your server name and account password, select the database EducationManager you just created below, and click test connection to see if the connection can be established, click OK.
　　
　　
After the connection is complete, you can see the database in the server resource manager (generally on the left side of VS, if not, you can call it by Crtl + Alt + S ).
　　

So far, the project has been established.