- Follow MSDev.pro blog on WordPress.com
Today’s Best Practic… on Sending notifications with Cor… Gaston on Areas in ASP.NET Core How to Use Microsoft… on How to use Microsoft Azure Key… Gaston on Areas in ASP.NET Core Gaston on Structuring your Excel –…
Category Archives: Databases
Why would you use Common Table Expressions?
Introduction In this article I suppose that you have a good understanding of SQL already. I will introduce some concepts very briefly before moving on to Common Table Expressions. Below you can find the relevant database diagram of the database … Continue reading
Posted in Codeproject, Databases, Development, SQL Tagged Common table expressions, CTE Leave a comment
What is the role of the database?
Introduction Most non-trivial applications will use a database to store data. This database can be relational or not, but some data store will be needed. Most modern database management systems (DBMS) can do much more than just storing data, and … Continue reading
Posted in Architecture, Codeproject, Databases, Development, Entity Framework Tagged stored procedures;business logic;CRUD 2 Comments
Introduction After I published last week’s article somebody asked me why I stated that (in this case) the problem didn’t originate in having a function with logic, but merely having to work with a database that is not normalized. So let’s talk … Continue reading
Posted in Codeproject, Databases, Development Tagged Codd, Normalization Leave a comment