Program.cs

using AppWithReact.Models;
using Microsoft.EntityFrameworkCore;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.
builder.Services.AddControllers();
builder.Services.AddOpenApi();

// Configure MySQL Database
var connectionString = builder.Configuration.GetConnectionString("DefaultConnection");
builder.Services.AddDbContext<AppDbContext>(options =>
    options.UseMySql(connectionString, ServerVersion.Parse("8.0.0")));

// Add CORS policy
builder.Services.AddCors(options =>
{
    options.AddPolicy("AllowReactApp",
        builder =>
        {
            builder.WithOrigins("http://localhost:3001")
                   .AllowAnyHeader()
                   .AllowAnyMethod();
        });
});

var app = builder.Build();

// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.MapOpenApi();
    app.UseCors("AllowReactApp");
    app.UseDeveloperExceptionPage();
}

app.UseHttpsRedirection();
app.MapControllers();

// Populate Database if empty
using (var scope = app.Services.CreateScope())
{
    var services = scope.ServiceProvider;
    try
    {
        var context = services.GetRequiredService<AppDbContext>();
        
        // Use EnsureCreated instead of migrations
        context.Database.EnsureCreated();
        Console.WriteLine("✓ Database created successfully!");
        
        // Add sample data if empty
        if (!context.TodoLists.Any())
        {
            // Create default todo lists
            var personalList = new TodoList
            {
                Name = "Personal Tasks",
                Description = "Daily personal tasks and reminders",
                CreatedAt = DateTime.UtcNow
            };
            
            var workList = new TodoList 
            {
                Name = "Work Projects", 
                Description = "Office work and project tasks",
                CreatedAt = DateTime.UtcNow
            };
            
            context.TodoLists.AddRange(personalList, workList);
            await context.SaveChangesAsync();
            
            // Add sample items to personal list
            context.TodoItems.AddRange(
                new TodoItem 
                { 
                    Title = "Buy groceries", 
                    TodoListId = personalList.Id,
                    CreatedAt = DateTime.UtcNow,
                    DueDate = DateTime.UtcNow.AddDays(1)
                },
                new TodoItem 
                { 
                    Title = "Call dentist", 
                    TodoListId = personalList.Id,
                    CreatedAt = DateTime.UtcNow
                }
            );
            
            // Add sample items to work list
            context.TodoItems.AddRange(
                new TodoItem 
                { 
                    Title = "Finish project report", 
                    Description = "Complete the Q4 project analysis",
                    TodoListId = workList.Id,
                    CreatedAt = DateTime.UtcNow,
                },
                new TodoItem 
                { 
                    Title = "Team meeting", 
                    TodoListId = workList.Id,
                    CreatedAt = DateTime.UtcNow,
                }
            );
            
            await context.SaveChangesAsync();
            Console.WriteLine("✓ Added sample todo lists with items!");
        }
    }
    catch (Exception ex)
    {
        Console.WriteLine($"✗ Error creating database: {ex.Message}");
        if (ex.InnerException != null)
            Console.WriteLine($"Inner exception: {ex.InnerException.Message}");
    }
}

app.Run();