Hello,
I'm trying to learn how to write and save a new record to a SQL Server Db using LINQ.
When I run my code and view the data in the table, the new record isn't there. However, when I query the table, the new record shows up! When I close the project, open it up, and run the query the added record is gone.
When I added the Db, I told Visual Studio to save it in the project.
I'm using the Northwind sample Db.
Here's the code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim NewData As New Customer
NewData.Address = "98224 Ocean Rd"
NewData.City = "Cincinnati"
NewData.CompanyName = "Supplies For Feathers"
NewData.ContactName = "Ralph Owens"
NewData.PostalCode = "45058"
NewData.ContactTitle = "Owner"
NewData.Country = "USA"
NewData.CustomerID = "RKO65"
NewData.Fax = "513-555-5555"
NorthwindSampleDataContext1.Customers.InsertOnSubmit(NewData)
NorthwindSampleDataContext1.SubmitChanges()
NorthwindSampleDataContext1.Connection.Close()
Why doesn't this save my new record?
Thanks,
Ralph
I'm trying to learn how to write and save a new record to a SQL Server Db using LINQ.
When I run my code and view the data in the table, the new record isn't there. However, when I query the table, the new record shows up! When I close the project, open it up, and run the query the added record is gone.
When I added the Db, I told Visual Studio to save it in the project.
I'm using the Northwind sample Db.
Here's the code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim NewData As New Customer
NewData.Address = "98224 Ocean Rd"
NewData.City = "Cincinnati"
NewData.CompanyName = "Supplies For Feathers"
NewData.ContactName = "Ralph Owens"
NewData.PostalCode = "45058"
NewData.ContactTitle = "Owner"
NewData.Country = "USA"
NewData.CustomerID = "RKO65"
NewData.Fax = "513-555-5555"
NorthwindSampleDataContext1.Customers.InsertOnSubmit(NewData)
NorthwindSampleDataContext1.SubmitChanges()
NorthwindSampleDataContext1.Connection.Close()
Why doesn't this save my new record?
Thanks,
Ralph