While trying to save my changes in my database table EmpTable, no commit in database takes place.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Linq;
namespace ConsoleApplication_
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("Working Fine");
DataBase1ClassDataContext dc = new DataBase1ClassDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True");
Table<EmpTable> t = dc.EmpTables;
foreach (var i in t)
{
Console.WriteLine(i.Id+" "+i.name+" "+i.Address+" "+i.contact+" "+i.GetType());
}
List<EmpTable> l = dc.EmpTables.ToList();
for (int j = 0; j < l.Count(); j++)
{
Console.WriteLine(l[j].Id + " " + l[j].name + " " + l[j].Address + " " + l[j].contact + " " + l[j].GetType());
}
label1:
Console.WriteLine("1 for inserting data, 2 for exit");
int a = Convert.ToInt32(Console.ReadLine());
Console.WriteLine();
EmpTable obj = new EmpTable();
switch (a)
{
case 1:
{
Console.Write("Enter a new unique ID: ");
obj.Id = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Your new id is : "+obj.Id);
Console.Write("Enter name: ");
obj.name = Console.ReadLine();
Console.Write("Enter address: ");
obj.Address = Console.ReadLine();
Console.Write("Enter contact no.: ");
obj.contact = Console.ReadLine();
dc.EmpTables.InsertOnSubmit(obj);
dc.SubmitChanges();
Console.WriteLine("INSERTED. . . :)");
dc = new DataBase1ClassDataContext();
t = dc.EmpTables;
foreach (var i in t)
{
Console.WriteLine(i.Id + " " + i.name + " " + i.Address + " " + i.contact + " " + i.GetType());
}
Console.WriteLine("To operate again,");
goto label1;
}
case 2:
Console.WriteLine("Press any key to exit,\nExiting . . .");
break;
default:
Console.WriteLine("Wrong Entry, Try Again");
goto label1;
}
Console.ReadKey();
}
}
}
Whenever I run my code, it shows only the data currently from the table which I have manually inserted.
Please help.
Important: I have a primary key in my table already present.
