So, what can I ask about on Stack Overflow? Is it okay to ask for help with a homework project?! For help with debugging my code? If not those, then what does make an okay question? And what makes a really good question? (Does it have to include code?)
Or what if I'm into Open Source software? There’s opensource.stackexchange.com, that looks good… but what if I’m interested in close relatives of open…
If you find yourself needing to compare and merge table data between instances of SQL Server from time to time, this article will show you that it's not that hard to roll your own general purpose utility to deal with this, using dynamic SQL. And to make things even easier, I've also made the finished code available as a new, lightweight, free, open source, pure-SQL, SQL Server data comparison and reconciliation tool, now up on GitHub and NuGet. 😊
In a widely linked article, from a few years ago now, Sam Saffron asks what to do about ‘that annoying INSERT problem’ in micro-ORMs.
His question still applies.
When you take a user object and use it to create an INSERT statement for a database, you have to deal with two problems: auto-incrementing primary keys, and database column defaults.
All databases have some method specifically designed to get back the latest primary key value used in an INSERT, such as:
on SQL Server, or:
Harder, and the problem Sam Saffron’s article was particularly concerned with, are…
There have been articles for years presenting yet another new .NET data access layer or micro-ORM and then drily asking, “Do we need yet another new .NET data access layer?”
So do we? Still? Really?
I believe we do, and this is the story of how I’ve come to put a new one — or rather, a re-write and update to one of the best — on the open-source ‘market’ (well it’s free, but you see what I mean!).
A micro-ORM is a very lightweight object-relational mapping tool.
It should convert the output of SQL calls into objects in your…
I've programmed for several (actually, many…!) years, now, but I've only started working on open-source software software relatively recently.
Here are a few pointers gathered from those recent experiences.
This article focuses on the GitHub Issue/Fork/Pull Request workflow, but most of what I say should be applicable elsewhere.
Just because you're allowed to offer changes to a project, and to take your own copy to do whatever the license allows (which might be, but isn’t always, whatever you want), that doesn't mean it's your project. …
Author of Mighty micro-ORM for .NET Core, SQL & web API developer, some time computer game 3D graphics lead programmer.