static void Main(string[] args)
{
var optionsBuilder = new DbContextOptionsBuilder <LyricsDbContext>();
optionsBuilder.UseSqlServer("server=(LocalDb)\\MSSQLLocalDB; database=LyricsDB; Integrated Security=true");
db = new LyricsDbContext(optionsBuilder.Options);
db.Database.EnsureDeleted();
db.Database.EnsureCreated();
SeedUser().GetAwaiter().GetResult();
using (var reader = new StreamReader(@"C:\Users\klyub\Desktop\Projects\Open-Lyrics\server\src\Sandbox\songdata.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
var records = csv.GetRecords <LyricModel>().ToList();
SeedLyrics(records).GetAwaiter().GetResult();
}
Console.WriteLine("Finished seeding database.");
Console.ReadLine();
}
public UserEfRepository(LyricsDbContext dbContext)
{
_dbContext = dbContext;
}
