.NET

SQLite in C#? [Part 2]

SQLite in C#? [Part 2]

Building off the previous tutorial  SQLite in C# [Part 1] we are going to get a little more in detail with SQLite and populate our database with some information that we can pull back out later.

Lets start off with inserting information into our database.  We will do this in a similar fashion as we did creating our database table.  By creating a query string, passing it to a SQLiteCommand, and then executing the command.

Continue reading →

Posted by DCCoder in Programming, Tutorials, 0 comments
SQLite in C#? [Part 1]

SQLite in C#? [Part 1]

I can’t tell you how many times I am working on an application that I want to store data in an organized fashion but I don’t want the dependency of an external server.  Maybe I want to be able to use the application offline?  Or maybe the device I am running it on doesn’t have the ability to hold a database server.

Enter the realm of SQLite.  I have used it extensively in the past with simple Python and PHP applications, but now I figured I’d give a good overview of using it with C# and .NET.

Continue reading →

Posted by DCCoder in Programming, Tutorials, 0 comments
C# 7.1 Update

C# 7.1 Update

Last month Microsoft released Visual Studio 2017.3 and with it C#’s latest minor upgrade C# 7.1!  C#’s latest update includes four new (very useful) features that I am honestly very excited about.

  • async Main method
  • default literal expressions
  • inferred tuple names

Below I’ll go into some detail on each of the new features and show some examples of each, along with how to update your current project to the new C#7.1 update.

Continue reading →

Posted by DCCoder in Programming, 0 comments