A Blog About Random Computer Subjects
Summary In this post, I’m going to explain a couple techniques and tools that every developer should know. If you are just graduating from college and you are looking for a .Net job, learn these simple techniques and advance your career. If you’re a mid-level to advanced .Net developer and you don’t know these tools … Read moreWhat .Net Developers Should Know about MS SQL and IIS
Summary In this blog post I’m going to demonstrate a simple .Net MVC project that uses MS SQL server to access data. Then I’m going to show how to use Redis caching to cache your results to reduce the amount of traffic hitting your database. Finally, I’m going to show how to use the AutoFac … Read more.Net MVC Project with AutoFac, SQL and Redis Cache
Summary Let’s do something different. I’m going to install the latest version of MySQL, which is version 5.7, which is advertised to be 3x faster. I’m going to compare some basic database operations between the 32 bit version of MySQL, with the 64 bit version of Microsoft SQL Server 2014 (unfortunately, the MySQL msi is … Read moreMySQL
Summary In this blog post I’m going to demonstrate how to lazy load your data using Entity Framework and SQL Server. The purpose is to write an object that returns program settings stored in a table, but read from the table only once during the lifetime of the program. The Data In a database named … Read moreLazy Loading Data
Summary I’ve done these ad-hoc ORM performance tests in the past. In this test I’m going to re-test the latest Entity Framework (version 6.1.3) against the latest Linq-to-SQL version. I’ll be using EF code-first this time to make sure there isn’t any extra overhead. I’ll also be using Visual Studio 2013. The Hardware and Software … Read moreEntity Framework 6.1.3 vs. Linq2SQL vs. NHibernate Smackdown!
Summary Caching is a very large subject and I’m only going to dive into a small concept that uses Redis, an abstract caching class, and a dummy caching class for unit testing and show how to put it all together for a simple but powerful caching system. Caching Basics The type of caching I’m talking … Read moreData Caching with Redis and C#
Summary This is going to be a short post on how to query an MS SQL Server database and produce XML output. The Query There are two formats that you can use when you want to convert a query result into XML, Elements format and Properties Format. The following query will select from a table … Read moreExporting XML From MS SQL Server
Summary In this blog post I’m going to demonstrate how to do a bulk data insert using ADO. I’ll be adding code to my helper set of tools so that you can use the ADO database code at my GitHub account to write clean ADO database methods. Bulk Inserts The C# SqlClient library contains a … Read moreBulk Data Inserts
Summary I’ve published a few blog posts on the usage of SQLLocalDB with NHibernate. Now I’m going to demonstrate how easy it is to use with EF. In fact, SQLLocalDB can be used with ADO queries and LINQ-To-SQL. If you’re dealing with legacy code and your methods use a lot of database access operations, it … Read moreEntity Framework Unit Testing with SQLLocalDB
Summary If you’re an old-hat with databases, this blog post will not be new to you. I’m going to show some capabilities of SQL Server that will reveal how powerful a database server can be. These “secrets” (OK, they’re really not secret to anybody with a browser and Google) actually apply to other data servers … Read moreSQL Server Secrets…