<div>
<div class="content wysiwyg-content">
I would like to know how can I use LINQ to insert data into a table.<br />
I have built a registration form with lots of textboxes as input and I'd like to give a shot to use linq. I have no problem using stored proc in inserting records but I'd like to give LINQ a try<br />
to see if it is better.<br />
<br />
Please sshow code and example how is it done. Also what is the advantage if I switch to this method other than the stored procedure approach.
</div>
</div>


I would like to know how can I use LINQ to insert data into a table.
I have built a registration form with lots of textboxes as input and I'd like to give a shot to use linq. I have no problem using stored proc in inserting records but I'd like to give LINQ a try
to see if it is better.

Please sshow code and example how is it done. Also what is the advantage if I switch to this method other than the stored procedure approach.

Inserting data using LINQ

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although ports exist for Java, PHP, JavaScript and ActionScript. LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources.