Azim Posts - Answer Overflow

Azim

•Created by Azim on 11/10/2024 in #help

Entity Framework Foreign Key restraint

Hi all, I'm trying to make an appointment scheduling system. The appointment section has its own database linked to a patients model and an appointment model. The error happens when I try save a new appointment -

_appointmentContext.SaveChanges();

_appointmentContext.SaveChanges();

These are my models:

    public class AppointmentDbContext : DbContext
    {
        public DbSet<Appointment> Appointments { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            // Set the file location for the patient database
            optionsBuilder.UseSqlite("Data Source=appointment.db");
        }
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Appointment>()
                .HasOne(a => a.Patient)
                .WithMany(p => p.Appointments) // Matches Patient.Appointments
                .HasForeignKey(a => a.PatientId)
                .OnDelete(DeleteBehavior.Cascade);

            modelBuilder.Entity<Appointment>()
                .HasOne(a => a.User)
                .WithMany() 
                .HasForeignKey(a => a.UserId)
                .OnDelete(DeleteBehavior.Restrict);
        }

        public enum AppointmentStatus 
        {
            Completed = 1,
            Scheduled = 2,
            Cancelled = 3,


        } //UserAccountType

        public class Appointment
        {
            public int Id { get; set; }
            public DateTime Scheduled { get; set; }
            public AppointmentStatus Status { get; set; }

            //navigation properties 
            public int PatientId { get; set; }
            public Patient Patient { get; set; }
            public int UserId { get; set; }
            public User User { get; set; }
        }
    }
}

    public class AppointmentDbContext : DbContext
    {
        public DbSet<Appointment> Appointments { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            // Set the file location for the patient database
            optionsBuilder.UseSqlite("Data Source=appointment.db");
        }
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Appointment>()
                .HasOne(a => a.Patient)
                .WithMany(p => p.Appointments) // Matches Patient.Appointments
                .HasForeignKey(a => a.PatientId)
                .OnDelete(DeleteBehavior.Cascade);

            modelBuilder.Entity<Appointment>()
                .HasOne(a => a.User)
                .WithMany() 
                .HasForeignKey(a => a.UserId)
                .OnDelete(DeleteBehavior.Restrict);
        }

        public enum AppointmentStatus 
        {
            Completed = 1,
            Scheduled = 2,
            Cancelled = 3,


        } //UserAccountType

        public class Appointment
        {
            public int Id { get; set; }
            public DateTime Scheduled { get; set; }
            public AppointmentStatus Status { get; set; }

            //navigation properties 
            public int PatientId { get; set; }
            public Patient Patient { get; set; }
            public int UserId { get; set; }
            public User User { get; set; }
        }
    }
}

10 replies

CC#

•Created by Azim on 10/29/2024 in #help

Is there a way to make a search bar for a datagrid in WPF?

Hi all, I'm using the entity framework for my database, I'm trying to make a search bar for one of the databases but I'm struggling on how to do it. Is there any advise or guides that can help me to make this, I had a look only but couldn't find anything related to my issue...unless I'm looking in the wrong place. I can send my code if needed.

4 replies

Gaming

Programming