Windows Console App C# .Net 6 mit EntityFrameworkCore 6+ SQL Server Tabellen bearbeiten

using Database;

using Microsoft.EntityFrameworkCore;

namespace ConsApp_DB02

{

    internal class Program

    {

        static void Main(string[] args)

        {

            Console.WriteLine("Console With Entity Framework");

            string connectionstring = @"Server=.\sqlexpress;Database=codedocu_de;Trusted_Connection=True;MultipleActiveResultSets=true;Encrypt=false";

            var dbOptions = new DbContextOptionsBuilder<ApplicationDbContext>().UseSqlServer(connectionstring).Options;

            using (var dbContext = new ApplicationDbContext(dbOptions))

            {

                var articles = dbContext.tbl_Articles.ToList().Take(10);

                foreach (var article in articles)

                {

                    Console.WriteLine($"Title: {article.Content_Title}");

                }

            }

            Console.WriteLine("-DONE-");

        }

    }

}

using DataModels;

using Microsoft.EntityFrameworkCore;

namespace Database

{

    public class ApplicationDbContext : DbContext

    {

        public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options): base(options) { }

        public DbSet<ArticleDbModel> tbl_Articles { get; set; }

    }

}

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

namespace DataModels

{

    [Table(name: "tbl_Articles")]

    public class ArticleDbModel

    {

        [Key]

        public string GuidArticle { get; set; } = string.Empty; //guid

        //[MaxLength(36)]

        //public string? GuidUser { get; set; } = string.Empty;    //guid max 36 charakters

        //[Required]

        //[MaxLength(255)]

        public string? Content_Title { get; set; } = string.Empty;

        //public string? Content_Text { get; set; } = string.Empty;

        //public string? Content_Html { get; set; } = string.Empty;

        //[MaxLength(450)]

        //public string? Folder { get; set; } = string.Empty;

        //[MaxLength(255)]

        //public string? Keywords { get; set; } = string.Empty;

        //public DateTime DateCreated { get; set; } = DateTime.Now;

        //public DateTime DateEdit { get; set; } = DateTime.Now;

    }

}