[RESOLVED] LINQ-To-SQL - Simple Insert

[eclipsed4utoo]

I am having a problem getting LINQ to do a simple insert a specific table. I get a compile error that states:
'System.Data.Linq.Table<TimeSheet.Customer>' does not contain a definition for 'Add' and no extension method 'Add' accepting a first argument of type 'System.Data.Linq.Table<TimeSheet.Customer>' could be found (are you missing a using directive or an assembly reference?)"


private void AddCustomer()
{
try
{
Customer customer = new Customer();
customer.Name = txtName.Text;
customer.Address1 = txtAddress1.Text;
customer.Address2 = txtAddress2.Text;
customer.City = txtCity.Text;
customer.State = txtState.Text;
customer.ZipCode = txtZipCode.Text;
customer.Contact = txtContactName.Text;
customer.Email = txtEmail.Text;
customer.PhoneNumber = txtPhoneNumber.Text;

db.Customers.Add(customer); //Compile error is here

db.SubmitChanges();

lblInformation.Text = "Customer Added successfully";
lblInformation.Visible = true;

timer1.Enabled = true;
}
catch
{
lblInformation.Text = "Adding customer failed.";
lblInformation.Visible = true;

timer1.Enabled = true;
}
}


here is the database table layout:
CREATE TABLE [dbo].[Customers](
[CustomerID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](255) NOT NULL,
[Address1] [varchar](255) NULL,
[Address2] [varchar](255) NULL,
[City] [varchar](50) NULL,
[State] [varchar](100) NULL,
[ZipCode] [varchar](50) NULL,
[Contact] [varchar](150) NULL,
[PhoneNumber] [varchar](15) NULL,
[Email] [varchar](50) NULL,
CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED
(
[CustomerID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Any ideas?

[eclipsed4utoo]

nevermind, I figured it out.

For those that want to know, I replaced this:


db.Customers.Add(customer);


with this:


db.Customers.InsertOnSubmit(customer);