Linq to SQL not inserting data onto the DB
- by Jesus Rodriguez
Hello!
I have a little / weird behaviour here and Im looking over internet and SO and I didn't find a response.
I have to admit that this is my first time using databases, I know how to use them with SQL but never used it actually.
Anyway, I have a problem with my app inserting data, I just created a very simple project for testing that and no solution yet.
I have an example database with Sql Server
Id - int (identity primary key)
Name - nchar(10) (not null)
The table is called "Person", simple as pie.
I have this:
static void Main(string[] args)
{
var db = new ExampleDBDataContext {Log = Console.Out};
var jesus = new Person {Name = "Jesus"};
db.Persons.InsertOnSubmit(jesus);
db.SubmitChanges();
var query = from person in db.Persons select person;
foreach (var p in query)
{
Console.WriteLine(p.Name);
}
}
As you can see, nothing extrange.
It show Jesus in the console. But if you see the table data, there is no data, just empty. I comment the object creation and insertion and the foreach doesn't print a thing (normal, there is no data in the database)
The weird thing is that I created a row in the database manually and the Id was 2 and no 1 (Was the linq really playing with the database but it didn't create the row?)
There is the log:
INSERT INTO [dbo].Person
VALUES (@p0)
SELECT CONVERT(Int,SCOPE_IDENTITY()) AS [value]
-- @p0: Input NChar (Size = 10; Prec = 0; Scale = 0) [Jesus]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.30729.4926
SELECT [t0].[Id], [t0].[Name]
FROM [dbo].[Person] AS [t0]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.30729.4926
I am really confused, All the blogs / books use this kind of snippet to insert an element to a database.
Thank you for helping.
