c# – SQL for the first time


Right now i need to store stuff into a database via C#.
I have a csv file that i am reading from. I am using LiteDB from a previous assignment but because my file is too big i cannot use it to store stuff in.

So i now need to use SQL. My problem is that in every tutorial or even the basic sites with some of the most simplest examples are hard to understand because they tend not to explain as well as people can do when they write it to me personally.

Everything in my code is setup so that i can change from LiteDB to SQL without much problem because they way i stored it and read the file shouldn’t have much of a problem with the way i put it in a database.

This is what my code looks like now:

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using LiteDB;
using Microsoft.VisualBasic.FileIO;
namespace SQL2
    //By Karwan.
    //I have picked some random amount of imdb movies lists.
    //Its big and takes a long time to actually make into a database...
    //But it works fine.

    /// <summary>
    /// Movie Class.
    /// </summary>
    class Movies
        public string Imdb_ID { get; set; }
        public string Title { get; set; }
        public string OriginalTitle { get; set; }
        public string Year { get; set; }
        public string Date_Published { get; set; }
        public string Genre { get; set; }
        public int DurationInMinutes { get; set; }
        public string MadeInWhichCountry { get; set; }
        public string Language { get; set; }
        public string DirectorName { get; set; }

    /// <summary>
    /// Main Program Class.
    /// </summary>
    class Program
        /// <summary>
        /// Main method.
        /// </summary>
        /// <param name="args"></param>
        static void Main(string() args)
            //List for movies.
            List<Movies> MovieList = new List<Movies>();

            //List parser.
            using (TextFieldParser parser = new TextFieldParser("m.csv"))
                parser.TextFieldType = FieldType.Delimited;

                //Read until there is nothing else to read.
                while (!parser.EndOfData)
                    string() fields = parser.ReadFields();

                    Movies m = new Movies
                        //Was forced by the program to NOT have any integers for 
                        //some reason... i could not use values like "Year" or "Date_Published
                        //with int values because the program kept giving me a value exception 
                        //because "It isn't an integer". But it is, not sure what caused it.
                        //But it works fine with all strings. 
                        Imdb_ID = fields(0),
                        Title = fields(1),
                        OriginalTitle = fields(2),
                        Year = fields(3),
                        Date_Published = fields(4),
                        Genre = fields(5),
                        DurationInMinutes = int.Parse(fields(6)),
                        MadeInWhichCountry = fields(7),
                        Language = fields(8),
                        DirectorName = fields(9)

                    //Add to list. 

                //Create database and add to database.
                using (var db = new LiteDatabase("MyDataBase"))
                    var db_movies = db.GetCollection<Movies>("Movies!");

                    foreach(var movie in MovieList)



All i need is to know how to create an SQL database and how to store stuff in it.
If anyone would be kind enough to give me an example then that would be awesome!