His feedback and insights were invaluable as is evident not only in the final version of my course, but in his own courses on ASP.NET Core, C# and more. There are 16 modules if you count the course overview which is just a 1.5 minute “trailer” about the course. This is not just a refresh Software development articles for dummies of the recent EF Core 5 Getting Started course. In fact, I retired the samurais and have introduced a book publisher as the domain this time. Below is the list of module titles for my new course. Julie started the Vermont.NET User Group in 2002 and is still leading it 12 years later.

Therefore, when recording a course, which may take me many many weeks, I tend to leave one of my monitors at 1280×720. But I’m constantly doing other things on that monitor such as email or writing and that resolution is discomforting. I did all of the work in Visual Studio on my Windows machine because there is a very feature rich extension called AWS Toolkit for Visual Studio. There are also extension for VS Code, JetBrains’ Rider and other IDEs (not just for .NET). The ones for VS Code and Rider are more focused on serverless apps so they don’t have all of the features of the one for Visual Studio. So I have spent quite a bit of time sating that curiosity.

• I was writing a small ASP.NET Core app and wanted to store its secrets– some connection strings – in an Azure Key Vault to keep them out of my source code.
• Leading software conferences around the world since 2003.
• I did all of the work in Visual Studio on my Windows machine because there is a very feature rich extension called AWS Toolkit for Visual Studio.
• Needs to review the security of your connection before proceeding.
• Julie shows you how the development team listened to the community for this latest release as she explores all the cool new tools.

I’m writing this article to share some of the not-so-obvious ways to use ClickOnce for application deployment. For background on EF, see my previous article, “Introducing ADO.NET Entity Framework” in the Nov/Dec 2007 issue of CODE Magazine. In the Add role assignment form, select Owner from the Role drop-down. Leave the Assign access to option at its default . My speaking engagements and mentorship also lean heavily on practices from Domain-Driven Design. Needs to review the security of your connection before proceeding.

POCO Support Comes to Entity Framework 4

Click on User next to Roles and filter on global to select Global Administrator. So the rest of this blog post is simply relaying what Joe taught me. DockerCon Live 2021 is coming up this Thursay, May 27. New this year, in addition to regular sessions, are a number of community rooms hosted by Docker Captains. Feel free to contact me about working with your team on site, remotely or even in Vermont where I live, if you’d like an excuse to visit my beautiful state. I am the author of the highly acclaimed “Programming Entity Framework” books, the MSDN Magazine Data Points column and many popular videos on Pluralsight.com.

The first operation is separate from the transaction. So I would have to do a Reload and database hit to get around that problem. When it’s time to deploy your app, and you’re using Azure SQL and Azure, you’re going to want to use Azure Managed Identity to authenticate and access the database. Julie shows you that it’s not even a little bit scary. But I still had to tear a few more hairs out before I got it working and came to love ClickOnce.

Julie blogs at thedatafarm.com/blog, is the author of the highly acclaimed “Programming Entity Framework” books, and many popular videos on Pluralsight.com. That article is in the Code Magazine May/June 2021 issue. In this blog post I am going to focus on the problem of the personal account. In-House vs Outsourced Software Development You can find details about accessing the Key Vault from the application in the article. This blog post is about a very particular problem you might have with some Azure services if your Azure subscription is tied to a personal account and not an Office 365 or Microsoft 365 identity.

The secrets API asks the identity API to discover any managed identities on your machine if they are not fed directly to the application. I log in to visualstudio.com, my Visual Studio subscription and my Microsoft MVP account with that same personal account. @onefootswill I’m not sure I understood correctly the scenario you’re describing.

It is a set of Azure services that rely an Azure Active Directory for credential management – referred to as Managed Identity. One of the classic problems with database applications is refreshing stale data. Imagine a typical e-commerce site with products and categories.

The user has to be recognized as a subscription owner. Azure allows you to set up secondary subscription owners. I want to first describe how my Microsoft and Azure accounts are set up and how I encountered the problem then share how I was able to solve it. I’d also like to give a shout out to my friend and fellow Pluralsight author, Roland Guijt, who acted as tech reviewer as I created this course.

I’ve written two articles that were published in Code Magazine this summer and recently published a course on Pluralsight. I still love Azure , but I’m glad to have deeper familiarity of other options. This makes me a better developer as well as a better consultant to my clients. If you click on your login info on the top right corner of the portal, you may already have an easy option available for switching to the new account for logging in. The only other task on this page is to set a role for this user.

Julie Lerman’s World of Data

She was part of the original INETA leadership when it was a truly international organization and served on its board. In 2009, Julie introduced Vermont Code Camp and has been co-organizing this event annually. She was a founding board member of the Vermont Software Developer Alliance and served on the board for 3 years and is proud to be on the judging panel of HackVT, a 24 hour hack-athon in Vermont. Microsoft has recognized Julie in their MVP program every year since 2003.

VTSDA has morphed to the Vermont Technical Alliance and is an important player in the Vermont technical business community. Back in Visual Studio, I wove the Azure.Extensions.Aspnetcore.Configuration.Secrets package into my application to let it read from the key vault. This also requires referencing the Azure.Identity NuGet package. Perhaps my approach is flawed in that I am persisting 1 or two things along the way and not all in one big transaction.

Generic repository to update an entire aggregate

In my case, I returned to the key vault and created a new access policy for the new identity. While participating in a truly global community, my heart belongs to the tech community in Vermont. I founded the Vermont.NET user group in 2002 and we continue to have monthly meetings all these years later.

The challenge of bringing data from efficient storage engines such as SQL Server into object-oriented programming models is hardly a new one. Most developers address this challenge by writing complex data access code to move data between their applications and the database. This requires an understanding of the database so that you can access data either from the raw tables, from views, or from stored procedures. Julie Lerman is a Microsoft Regional director, Docker Captain, and a long-time Microsoft MVP who now counts her years as a coder in decades. She makes her living as a coach and consultant to software teams around the world. You can find Julie presenting on Entity Framework, Domain-Driven Design and other topics at user groups and conferences around the world.

With Visual Studio 2008 and .NET 3.5, developer’s data access options have increased substantially. In addition to using ADO.NET to create DataReaders or DataSets, Microsoft has added LINQ to SQL and Entity Framework as well as ADO.NET Data Services, which leverages those two. In addition to these new options, there are new syntaxes to learn. LINQ, which is built into Visual Basic and C#, has one implementation for LINQ to SQL and another for LINQ to Entities.

Tying an O365 Identity to my Azure Subscription

In Entity Framework, you have the option to use LINQ to Entities as well as two other ways of querying with Entity SQL, as you can see in Figure 1. Learn how to leverage Microsoft Identity via Azure Active Directory to secure a Web application. Julie shows you how to store a database’s connection string A Walkthrough of SQL Schema along with its elements in Azure Key Vault. It is formatted as an email address with the name of the user and the domain is a compressed version of the identity for the subscription and then onmicrosoft.com. Azure will populate the domain name tied to your subscription’s Azure Active Directory.

This is almost exactly what I’m doing now with a project, and it works quite well. I have an extension method that I attached to DbContext that I call in SaveChanges that checks all entities that have the interface and sets the EntityState. I am using the repository pattern to provide access to and saving of my aggregates. 📺 Watch my popular Pluralsight courses on EF Core and Domain-Driven Design My Pluralsight author page.

Julie has worked hard to share to her knowledge with other developers and to encourage more women to participate in the software industry. Along with many published articles in technology magazines such as MSDN Magazine, CODE Magazine and DevProConnections, Julie has been the author of the Data Points column in MSDN Magazine since early 2010. When Microsoft first released the Entity Framework, agile developers roundly criticized it. These developers hold the tenets of domain-driven development and testability very high.

()