{"id":1978,"date":"2021-06-14T12:00:00","date_gmt":"2021-06-14T10:00:00","guid":{"rendered":"https:\/\/kindsonthegenius.com\/blog\/build-a-complete-app-with-asp-net-c-sql-lite-part-2\/"},"modified":"2026-07-05T03:25:41","modified_gmt":"2026-07-05T01:25:41","slug":"build-a-complete-app-with-asp-net-c-sql-lite-part-2","status":"publish","type":"post","link":"https:\/\/kindsonthegenius.com\/blog\/build-a-complete-app-with-asp-net-c-sql-lite-part-2\/","title":{"rendered":"Build a Complete App with ASP.Net, C#, SQL Lite \u2013 Part 2"},"content":{"rendered":"

This is Part 2 of our complete application with Visual Studio, ASP.Net, C# and SQL Lite. In this part we, would plan the data model for our Hospital Management System.<\/p>\n

Plan and Setup the Domain Models<\/strong><\/h5>\n

The Domain models represents the objects that make up the HospitalMS database. For this tutorial, we would use the following 8 classes.<\/p>\n

Also note that the constructors for the classes are not given here for simplicity. So you need to generate the constructors(allArgsConstructor and noArgsConstructor) in the classes.<\/p>\n

Patient<\/strong> – this class represents a patient that is admitted to the hospital<\/p>\n

public<\/span> class<\/span> Patient<\/span>\r\n{\r\n    public<\/span> int<\/span> PatientId { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Firstname { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Lastname { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Email { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Address { get<\/span>; set<\/span>; }\r\n    public<\/span> Country Country { get<\/span>; set<\/span>; }\r\n    public<\/span> int<\/span> CountryId { get<\/span>; set<\/span>; }\r\n}\r\n<\/pre>\n
 <\/p>\n
Appointment<\/strong> – appointments can be booked by patients<\/p>\n
public<\/span> enum<\/span> Status\r\n{\r\n    New,\r\n    Confirmed,\r\n    Cancelled\r\n}\r\npublic<\/span> class<\/span> Appointment<\/span>\r\n{\r\n    public<\/span> int<\/span> AppointmentId { get<\/span>; set<\/span>; }\r\n    public<\/span> Patient Patient { get<\/span>; set<\/span>; }\r\n    public<\/span> int<\/span> PatientID { get<\/span>; set<\/span>; }\r\n    public<\/span> Physician Physician { get<\/span>; set<\/span>; }\r\n    public<\/span> int<\/span> PhysicianId { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Description { get<\/span>; set<\/span>; }\r\n    public<\/span> DateTime AppointmentDate { get<\/span>; set<\/span>; }\r\n    public<\/span> DateTime AppointmentTime { get<\/span>; set<\/span>; }\r\n    public<\/span> Status Status { get<\/span>; set<\/span>; }\r\n    public<\/span> int<\/span> DurationInMinutes { get<\/span>; set<\/span>; }\r\n\r\n}\r\n<\/pre>\n
 <\/p>\n
Room<\/strong> – when a patient is admitted, he is assigned to a room<\/p>\n
public<\/span> class<\/span> Room<\/span>\r\n{\r\n    public<\/span> int<\/span> RoomID { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Description { get<\/span>; set<\/span>; }\r\n    public<\/span> int<\/span> Number { get<\/span>; set<\/span>; }\r\n}\r\n<\/pre>\n
 <\/p>\n
Admission<\/strong> – records details of patient’s admission<\/p>\n
public<\/span> class<\/span> Admission<\/span>\r\n{\r\n    public<\/span> int<\/span> AdmissionId { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Complaint { get<\/span>; set<\/span>; }\r\n    public<\/span> Patient Patient { get<\/span>; set<\/span>; }\r\n    public<\/span> int<\/span> PatientId { get<\/span>; set<\/span>; }\r\n    public<\/span> Room Room { get<\/span>; set<\/span>; }\r\n    public<\/span> int<\/span> RoomId { get<\/span>; set<\/span>; }\r\n    public<\/span> DateTime AdmissionDate { get<\/span>; set<\/span>; }\r\n    public<\/span> DateTime AdmissionTime { get<\/span>; set<\/span>; }\r\n\r\n}\r\n<\/pre>\n
 <\/p>\n
Discharge<\/strong> – keeps track of when\u00a0 patient recovers and is discharged<\/p>\n
public<\/span> class<\/span> Discharge<\/span>\r\n{\r\n    public<\/span> int<\/span> DischargeId { get<\/span>; set<\/span>; }\r\n    public<\/span> Patient Patient { get<\/span>; set<\/span>; }\r\n    public<\/span> int<\/span> PatientId { get<\/span>; set<\/span>; }\r\n    public<\/span> DateTime DischargeDate { get<\/span>; set<\/span>; }\r\n    public<\/span> DateTime DischargeTime { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Details { get<\/span>; set<\/span>; }\r\n}\r\n<\/pre>\n
 <\/p>\n
Physician<\/strong> – a record of doctor and nurses<\/p>\n
public<\/span> class<\/span> Physician<\/span>\r\n{\r\n    public<\/span> int<\/span> PhysicianId { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Firstname { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Lastname { get<\/span>; set<\/span>; }\r\n    public<\/span> List<Specialty> Specialties { get<\/span>; set<\/span>; }\r\n    public<\/span> DateTime DateOfHire { get<\/span>; set<\/span>; }\r\n}\r\n<\/pre>\n
 <\/p>\n
Specialty<\/strong> – a physician can have one or more specialties<\/p>\n
public<\/span> class<\/span> Specialty<\/span>\r\n{\r\n    public<\/span> int<\/span> SpecialtyId { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Description { get<\/span>; set<\/span>; }\r\n}\r\n<\/pre>\n
 <\/p>\n
Country<\/strong> – list of countries.<\/p>\n
public<\/span> class<\/span> Country<\/span>\r\n{\r\n    public<\/span> int<\/span> CountryId { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Name { get<\/span>; set<\/span>; }\r\n    public<\/span> string<\/span> Capital { get<\/span>; set<\/span>; }\r\n}\r\n<\/pre>\n
 <\/p>\n
The complete database diagram is given below\u00a0 and please take some time to study it and and understand how the tables relate.<\/p>\n
\"HospitalMS<\/a>
HospitalMS Database Diagram<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"
This is Part 2 of our complete application with Visual Studio, ASP.Net, C# and SQL Lite. In this part we, would plan the data model … <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[311],"tags":[],"class_list":["post-1978","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1978","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/comments?post=1978"}],"version-history":[{"count":1,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1978\/revisions"}],"predecessor-version":[{"id":2146,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1978\/revisions\/2146"}],"wp:attachment":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/media?parent=1978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/categories?post=1978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/tags?post=1978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}