Seeding a Many to Many With Entity Framework and C# Dynamic

In the previous post, we created a single table (speakers) with Entity Framework Code First from a JSON file with Visual Studio 2015.  Now we will add a sessions table that has a many to many relationship to the speakers table.  That is, speakers can have multiple sessions and sessions can have multiple speakers.  We do that but simply creating another entity (sessions) and add to it a List of speakers and then adding to the existing speakers table a list of sessions.  The new table (models) look as follows. GitHub Repo: [crayon-5928ffc1b6b3d612154753/] Then,  we need to add sessions data (from the JSON file) but when we add the sessions, we need to add … Continue Reading

Seed Entity Framework Code First With JSON Using C# Dynamic

If you just want the short version, go to the this GitHub Repository and you’ll find a very simple project that I’ll explain in more detail here. Below are the steps necessary to achieve converting JSON into Entity Framework Seeded data. Copy the JSON file into your Visual Studio project and make the build action (file property in VS) Embedded Resource. Next, find out the name of the embedded resource. If you just don’t know it or don’t want to spend time disassembling the project you can use the GetManifestResourceNames() method as shown below.  I find that is quicker and I don’t typically have those tools loaded when I need or want then. Once we have the manifest name, … Continue Reading

GitHub Visual Studio 2015 Extension, Getting Started

I’ve been using Git as my source control of choice for years now.  I’ve recently discovered the GitHub Visual Studio extension that takes some of the hassles away from this process.  Specifically, creating a new Git Repository from a Visual Studio 2015 project and publishing it to GitHub is always a small dance.  Now, it’s trivial and with this blog post, if I ever forget how (or you do), the simple steps and screen shots are here. Step 1 – Make sure you have the Visual Studio 2015 Git Extension installed.  To do that, simply go to Team/Manage Connections   and then verify the extension is installed (or install it)   Step 2 – Create a Visual Studio 2015 Project Just like any other project you would create with … Continue Reading

LINQ Support in Visual Studio 2015 Debugger Awesome

I’ve been wanting to do this for a very long time.  I’m in the debugger of Visual Studio 2015 and I have some data structure that is a collection of objects.  To find what I want, I’ve had to either write ugly conditional debugging statements or put in some temporary c# if statements to stop on what I wanted and examine it. Now, I can just write the LINQ code in the watch window of Visual Studio and see exactly what I want.  Check out the screen shot below and notice that I just typed in: meetupResults.results.Select(a=>a.urlname).ToList() and I got exactly what I wanted. Very nice! … Continue Reading


Get every new post delivered to your Inbox

Join other followers: