Stored Procedures using LINQ with VB.Net <p>Newby here and I cant understand why the data isnt staying in the table.</p> <p>The Stored Procedure:</p> <pre><code>ALTER PROCEDURE dbo.AccountAdd @AccountName nvarchar(50) ,@Address1 nvarchar(50) ,@Address2 nvarchar(50) ,@Address3 nvarchar(50) ,@Town nvarchar(50) ,@County nvarchar(50) ,@Postcode nvarchar(10) ,@Phone1 nvarchar(50) ,@Phone2 nvarchar(50) ,@Phone3 nvarchar(50) ,@Email1 nvarchar(50) ,@Email2 nvarchar(50) ,@ContactName nvarchar(50) ,@Position nvarchar(50) ,@AccountType nvarchar(50) AS INSERT INTO [dbo].[Accounts] ([AccountName] ,[Address1] ,[Address2] ,[Address3] ,[Town] ,[County] ,[Postcode] ,[Phone1] ,[Phone2] ,[Phone3] ,[Email1] ,[Email2] ,[ContactName] ,[Position] ,[AccountType]) VALUES (@AccountName ,@Address1 ,@Address2 ,@Address3 ,@Town ,@County ,@Postcode ,@Phone1 ,@Phone2 ,@Phone3 ,@Email1 ,@Email2 ,@ContactName ,@Position ,@AccountType) RETURN @@IDENTITY </code></pre> <p>The VB Code:</p> <pre><code>Dim db As New DBClassesDataContext Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click db.Connection.Open() Dim q = db.AccountAdd("Mark Cooney", "vv", "vv", "vv", "vv", "vv", "vv", "vv", "vv", "vv", "vv", "vv", "vv", "vv", "vv") db.Connection.Close() Label1.Text = q End Sub </code></pre> <p>So when I click button1, q equals a new id but the data isnt there!!</p> <p>What am I missing please? Sorry I'm trying to understand LINQ</p>