GC.Collect();
using (var con = new SQLiteConnection("Data Source=" + finalDbFileName + ";Version=3;"))
                {
                    con.Open();
                    using (var command = new SQLiteCommand(con))
                    {
                        using (var transaction = con.BeginTransaction())
                        {
                            string columns = ConfigurationManager.AppSettings["columnNames"].ToString();
                            foreach (NumberDetails numDetails in numberDetails.Where(s => s.DBName == DBName))
                            {
                                errorNUM = numDetails.Number.ToString();
                                string date = numDetails.Date.ToString();
                                if (!date.Contains("DATE") && !date.Equals("") && !date.Contains("date") && date.Length == 11)
                                {
                                    date = Convert.ToDateTime(numDetails.Date.ToString()).ToString("dd-MM-yyyy");
                                }
                                sim = numDetails.SimType;
                                string fnam = numDetails.Full_Name.Replace("'", "");
                                fnam = fnam.Replace("", "");
                                fnam = Regex.Replace(fnam, @"[^u0000-u007F]+", string.Empty);
                                if (simType == "" && sim != "")
                                {
                                    command.CommandText = "insert into `" + numDetails.Number.ToString().Substring(0, 5) + "` (" + columns + ") " +
                                           "select '" + numDetails.Number + "','" + numDetails.Full_Name.Replace("'", "") + "','" + numDetails.Address.Replace("'", "") + "','" + date.ToString() + "','" + circle + "','" + mobileOperator + "','" + numDetails.Alterno.Replace("'", "") + "','" + numDetails.IDProof.Replace("'", "") + "','" + numDetails.SimType + "' where not exists " +
                                           "(select number,full_name,address,circle,operator,SimType from `" + numDetails.Number.ToString().Substring(0, 5) + "`" +
                                           "where (number='" + numDetails.Number + "' AND full_name='" + numDetails.Full_Name.Replace("'", "") + "' AND address='" + numDetails.Address.Replace("'", "") + "'  AND circle='" + circle + "'  AND operator='" + mobileOperator + "' AND Alterno='" + numDetails.Alterno.Replace("'", "") + "' AND IDProof='" + numDetails.IDProof.Replace("'", "") + "' AND SimType='" + numDetails.SimType + "' )); ";
                                    command.ExecuteNonQuery();
                                }
                                else
                                {
                                    command.CommandText = "insert into `" + numDetails.Number.ToString().Substring(0, 5) + "` (" + columns + ") " +
                                            "select '" + numDetails.Number + "','" + fnam + "','" + numDetails.Address.Replace("'", "") + "','" + date.ToString() + "','" + circle + "','" + mobileOperator + "','" + numDetails.Alterno.Replace("'", "") + "','" + numDetails.IDProof.Replace("'", "") + "','" + simType + "' where not exists " +
                                            "(select number,full_name,address,circle,operator,SimType from `" + numDetails.Number.ToString().Substring(0, 5) + "`" +
                                            "where (number='" + numDetails.Number + "' AND full_name='" + fnam + "' AND address='" + numDetails.Address.Replace("'", "") + "' AND circle='" + circle + "'  AND operator='" + mobileOperator + "' AND Alterno='" + numDetails.Alterno.Replace("'", "") + "' AND IDProof='" + numDetails.IDProof.Replace("'", "") + "' AND SimType='" + simType + "' )); ";
                                    command.ExecuteNonQuery();
                                }
                            }
                            transaction.Commit();
                        }
                        command.CommandText = string.Empty;
                    }
                }

  GC.Collect();