ExtJS4.1 + MVC3 + Spring. NET1.3 + EF5 integration 2: generate a database

Entity Framework is Microsoft's. the O/R Mapping (O/R Mapping) solution developed based on NET is similar to NHibernate and belongs to the ORM framework. The advantages and disadvantages of the two are not well evaluated, if you need a friend, You can google it. The purpose of using the ORM framework is to facilitate database access operations and persistence. EF currently supports three construction methods: Database First, Model First, and Code First. This article is built using the Database First method. The other two methods will be written later, or please refer to the articles of other friends. Therefore, we need to start from generating the Database here. Based on the previous functional description, this article describes several tables in the database: the "category" table is used to save the "Tree" type data. Each category is similar to a "menu ", it is also displayed as a "permission" in the background, and has many-to-many relationships with "role. There may be multiple articles under each category for display in the foreground (user access module), such as news and consulting. Each category may have an "Upload configuration" for a file to constrain the size, format, storage location, and other information of the file to be uploaded. For image files, the "thumbnail" table defines how images are scaled, such as the scale and size." Ask "the table function is similar to the comment function. you can comment on an article ." Talent Recruitment "used to publish talent demand information," Personnel registration "table is the registration record of candidates. Here, I first download the pdm, SQL script, and the SQLite database file I generated near the database: SQLite client: SqliteStudio 2.1.2. SqliteStudio is a single file and does not need to be installed, after downloading the file, run it directly. Right-click the blank area on the left and select "add Database", and enter the location of the database file. In order to put the file in the App_Data directory of the Web project (the file name is db. s3db), shows: After the creation, right click on the left database file name and select "Connect", and then create table. run the SQL script to generate the database. The next step is to create an EF5 project.