// @nuget: Microsoft.SqlServer.Compact

// @nuget: Z.EntityFramework.Classic

// @nuget: Z.EntityFramework.Classic.SqlServerCompact

​

using System;

using System.Linq;

using System.Data.Entity;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

​

​

public class Program

{

    public static void Main()

    {

        // Custom configuration specific for .NET Fiddle

        Z.EntityFramework.Classic.EntityFrameworkManager.UseFiddleSqlCompact(System.Data.Entity.SqlServerCompact.SqlCeProviderServices.Instance, System.Data.SqlServerCe.SqlCeProviderFactory.Instance);

​

        int count = GenerateData();

        Console.WriteLine($"Created {count} objects.");

​

​

        using (var context = new EntityContext())

        {

            // TODO add each of the context items here.

            var list = context.Sample.ToList();

            // TODO add each of the context item names here

            FiddleHelper.WriteTable("Sample", list);            

        }

    }

​

    // TODO create one of these for every Model

    public static Api.Model.Sample[] GenerateSample()

    {

        return new Api.Model.Sample[] {

            new Api.Model.Sample("title1", "description1"),

            new Api.Model.Sample("title2", "description2")

            };

    }

    public static int GenerateData()

    {

        using (var context = new EntityContext())

        {

            // TODO add each generate fuction here

            context.Sample.AddRange(GenerateSample());

            return context.SaveChanges();   

        }

    }

​

    public class EntityContext : DbContext

    {

        public EntityContext() : base(@"Data Source=ZZZ_Projects.sdf") {}

​

        // TODO  Add your classes here

        // public DbSet<Api.Model.Sample> Sample { get; set; }

        public DbSet<Api.Model.Sample> Sample { get; set; }

    }

}

namespace Api.Model

{

​

    public abstract class WithID

    {

        [Key]

        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]

        public long Id { get; set; }

    }

​

    public abstract class WithTitle : WithID

    {

        [MaxLength(Sizes._64)]

        public string Title { get; set; }

    }

​

    public interface IWithLifetime

    {

        DateTimeOffset CreatedAt { get; set; }

        DateTimeOffset UpdatedAt { get; }

    }

​

    public static class Sizes

    {

        public const int _32 = 32;

        public const int _64 = 64;

        public const int _128 = 128;

        public const int _256 = 256;

        public const int COMPUTER_NAME = 15;

        public const int UNC_PATH = 260;

    }

    /////////////////////////////////////////////////////

    //////////  TODO Model definations below  ///////////

    /////////////////////////////////////////////////////

    public class Sample: WithTitle, IWithLifetime

    {

        [Required]

        [MaxLength(Sizes._128)]

        public string Description { get; set; }

        public DateTimeOffset CreatedAt { get; set; }

        public DateTimeOffset UpdatedAt { get; set; }

        public Sample(string title, string description)

        {

            this.Title = title;

            this.Description = description;

        }

    }

​

}

​

​

​