ORMs… can’t live with ‘em, can’t kill ‘em.


SQL Saturday Indianapolis - August 13, 2016

Object-relational mappers enable developers to work with relational databases like Microsoft SQL using the languages they know and love.  Sometimes that means that the developers don’t know the underlying queries and statements being sent to the database.  This doesn’t mean that the developers don’t love SQL.  It just means that they don’t know it yet.

In this session, we’ll look at the latest builds of Microsoft’s Entity Framework and see what programming tools developers use to work with SQL databases.  We’ll also take a look at Sequelize.  Sequelize is an open source ORM written in JavaScript for Node.js. 

We’ll take a look at code first development, advanced querying techniques, connecting to existing databases and migrations.  We’ll also take a look at lazy and eager loading techniques.  We’ll take a look at these two ORM’s from the eyes of the developer and the DBA.

Session Details: https://www.sqlsaturday.com/530/Sessions/Details.aspx?sid=52413

Comments

Post a Comment

Popular posts from this blog

Special Characters are Truly Special

Image
Do you remember the days before string interpolation in C#? I do. It was medieval. Those were truly the dark days of development. We would all use string formatting and concatenation and carried swords around to defend ourselves against giant beasts. Ok, maybe I'm the only one that was wearing a helmet but I'm kind of a weird guy. I think we can all agree that string concatenation is not all that fun. It might not be as dangerous as dragons, but it can still light your hair on fire when there is a bug in your code just to display some text. Classes in C# like StringBuilder helped make things safer but it wasn't all that readable. String.Format is easy but keeping the parameters in the right order isn't exactly a no brainer either. What if that code was just in a class behind a view? Can't we just put it in the view? In the code behind it was easily testable, but the context was lost, and it wasn't as simple as what we can do today. output = String.Format("
Read more

.NET Maui and VS Code

Image
  I was disappointed in the developer experience for .NET Maui and Visual Studio Code. I assumed that the popular debuggers and extensions would cover getting an app running. I am always up to date on my .NET and Visual Studio and Visual Studio Code so I just figured the tooling would be there. When the marketplace didn't really reveal a solution for me, I went searching. The best search result for me is the one that pointed me in the direction to get my .NET Maui CLI working.  That's right. I went to the CLI to get my IDE running the way I wanted it to. .NET MAUI with .NET CLI (Command Line Interface) Getting the .NET Maui workload and the maui-check command line tool installed really helped. Those installs made sure that the libraries and emulators were setup so I could run them without Visual Studio.  It also reminded me that I'll need some sort of emulator or device to connect VS Code to. dotnet new maui After running the CLI to create my solution and project, I realize
Read more

Where’s my phone update?

  http://www.microsoft.com/windowsphone/en-us/features/update-schedule-usa.aspx   I have a Samsung Focus.  If you look at the chart and details (as of today April 4th) I should get my February update 10 days to several weeks after AT&T gets thru testing.  AT&T isn’t done with testing at the time of this blog post.  So the February update should be called the June update and the March update could be called the July update.   I’m glad I don’t have a brick.  I’m glad I don’t have an Android 2.* and need to figure out if I can spend money on an app because it might actually not work on my version on the 2.x operating system.  I’m glad I don’t have an iPhone 4 with the bigger GBs and the cracked screens.   But how much different is copy and paste on the AT&T network than another network?  The Samsung update is in network testing right?  Or maybe that is just smoke and there is a bigger fire.  Tell me there is fire and I’ll not want the update. Otherwise quick puff
Read more