C#, Dapper & SQL: Interview Questions With Answers

Try your skills on this set of three interview questions involving a relational database - two tables and a many-to-many relationship - and a small application.
Design queries on this system of tables and materialize the data into domain objects. Make sure to avoid typical pitfalls in querying and, especially, in mapping the relational data to objects, and you'll be there!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👨 About Me 👨
Hi, I’m Zoran, I have more than 20 years of experience as a software developer, architect, team lead, and more. I have been programming in C# since its inception in the early 2000s. Since 2017 I have started publishing professional video courses at Pluralsight and Udemy and by this point, there are over 100 hours of the highest-quality videos you can watch on those platforms. On my YouTube channel, you can find shorter video forms focused on clarifying practical issues in coding, design, and architecture of .NET applications.❤️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚡️COPYRIGHT NOTICE:
The Copyright Laws of the United States recognize a “fair use” of copyrighted content. Section 107 of the U.S. Copyright Act states: “Notwithstanding the provisions of sections 106 and 106A, the fair use of a copyrighted work, including such use by reproduction in copies or phono records or by any other means specified by that section, for purposes such as criticism, comment, news reporting, teaching (including multiple copies for classroom use), scholarship, or research, is not an infringement of copyright." This video and our youtube channel, in general, may contain certain copyrighted works that were not specifically authorized to be used by the copyright holder(s), but which we believe in good faith are protected by federal law and the Fair use doctrine for one or more of the reasons noted above.

#codinginterview #csharp #dotnet

[adrianspikes]

Great questions!

I ran into this issue years ago with land owners and leases. Every owner had it's own row to assets but display needed to be concise and professional, just as you have demonstrated here.

I have a similar issue with a new project. I prefer not using enums for a my angular UI, like with my Blazor and razor UIs for states/counties and instead using a strategy similar to your video.

[arghasen]

If I have to use raw sql query, I would have used the stored procedure and in c# side just returning the models

[alfonsdeda]

Hi Zoran, great video!
Can you explain the part of order by book authors.Ordinal please? What is the difference between ordering by Id?

[alexlo]

Hi Zoran, Thank you for the Video. Could you mention what AI will generate for you?

[alexlo]

Should the code be asynchronous and use QueryAsync?

[AkosLukacs]

So the ad means you will publish a course on Dometrain?