StudioSharp Docs

Understanding Database - SQLSharp

Understanding Database - SQLSharp.

Sql sharp is tool that is used for online create relational database.

Advantages of Sql Sharp In Your Project.

  • Using sql sharp you may create multiple tables
  • Add multiple fields.
  • It having some default tables like below..

  • Default tables works
    • Role Table :- It used for handle User roles,
    • User Table :- It use to store users of your application.
    • RoleUser :- It is mapping table between Role and User table used for store Role of User.
    • Menu :- Menu table is store your application menu (create navigation bar of your application)
    • MenuPermission :- using this as per role and user you may setting of menu (which menu show to particular User and role)
Related Articles
Creating Database
Creating Table
Editing Table Name
Creating Columns
Editing Column
Adding Relationships
Editing Relationship
Export Database Diagram
Sql Sharp DataTypes