How does the magic happen

I think, behind the scenes, a call to InsertOnSubmit() is mapped to the Table.InsertOnSubmit() method (see http://msdn.microsoft.com/en-us/library/bb763516.aspx ) for the particular datatable and entity type you're using.

When you call SubmitChanges(), that method then generates the appropriate SQL INSERT command and sends that to the database.

Thanks for your answer Mahesh thats very helpful...

so if I was looking to create a method like InsertOnSubmit for example, id look to have a bunch of different underlining methods defined in my base class, one of which being Insert?

I guess the Framework is programmed in a way that it knows what Insert means... 

Thanks for your answer Mahesh thats very helpful...

so if I was looking to create a method like InsertOnSubmit for example, id look to have a bunch of different underlining methods defined in my base class, one of which being Insert?

I guess the Framework is programmed in a way that it knows what Insert means... 

There is always some implementation somewhere. You just don't know it. If you generated a database model using a framework, this method is implemented somewhere hidden and INSERT query is also hidden somewhere.