using System;

using System.Collections.Generic;

using System.Linq;

public class Program

{

    public void SaveCalibration()

        {

            Configuration.Instance.DBSettings = new Core.Application.Objects.DatabaseSettings

            {

                CatalogName = "vlt_rdt",

                InstanceName = "", //"SQLEXPRESS",

                Password = "Vtsadmin2014",

                PortNumber = "",

                ServerName = "localhost",

                Username = "sa"

            };

            var dbSettings = Configuration.Instance.DBSettings;

​

            string connstringtype = "VTSSQLConn";

​

            string connectionstring = @"Server=[dbserver]\[dbinstance];User Id=[dbuser];Password=[dbpassword];Integrated Security=[dbiss];Initial Catalog=[dbcatalog];Connection Timeout=1020;";

​

            connectionstring = connectionstring.Replace("[dbserver]", dbSettings.ServerName);

            connectionstring = connectionstring.Replace("[dbinstance]", dbSettings.InstanceName);

            connectionstring = connectionstring.Replace("[dbcatalog]", dbSettings.CatalogName);

​

            if (!string.IsNullOrEmpty(dbSettings.Username) && !string.IsNullOrEmpty(dbSettings.Password))

                connectionstring = connectionstring.Replace("[dbiss]", "false");

            else

                connectionstring = connectionstring.Replace("[dbiss]", "true");

​

            connectionstring = connectionstring.Replace("[dbuser]", dbSettings.Username);

            connectionstring = connectionstring.Replace("[dbpassword]", dbSettings.Password);

​

            Configuration.Instance.DBSettings.ConnectionString = connectionstring;

​

            var contextservice = new DataContextService(null);

            using (var ctx = contextservice.DataContext)  //CRASH HAPPENS HERE

            {

                TDTCameraCalibration newresult = null;

                IQueryable<TDTCameraCalibration> query = null;

​

                query = ctx.Set<TDTCameraCalibration>().Where(tm => tm.SerialNumber == "Serialnumber");

​

                if (query != null)

                {

                    TDTCameraCalibration cameraCalibration = query.FirstOrDefault();

                }

                else

                {

                    var cameraCalibration = new TDTCameraCalibration();

​

                    ctx.Set<TDTCameraCalibration>().Add(cameraCalibration);

                }

                ctx.SaveChanges();

            }

        }

}