CSharp · Console
// @nuget: EntityFramework
// @nuget: EntityFramework.SqlServerCompact
// @nuget: Microsoft.SqlServer.Compact
// @nuget: Z.EntityFramework.Extensions
using System;
using System.Data.Entity;
using System.Linq;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.ComponentModel.DataAnnotations;
public class Program
{
public static void Main()
{
InsertData();
using (var context = new BookStore())
{
context.Database.Log = Console.WriteLine;
var authors = context.Authors
.AsNoTracking()
.ToList();
}
}
public static void InsertData()
{
using (var context = new BookStore())
{
for(int i = 1; i < 1000; i++)
{
Author author = new Author()
{
Name = "Author " + i,
};
context.Authors.Add(author);
}
context.SaveChanges();
}
}
public class BookStore : DbContext
{
public BookStore() : base(FiddleHelper.GetConnectionStringSqlServer())
{
}
public DbSet<Author> Authors { get; set; }
}
public class Author
{
public int AuthorId { get; set; }
public string Name { get; set; }
}
}