LINQ to SQL: how to insert a record into a view?

Question

I use Linq for SQL for database operations and try to perform insert operations in VIEW, it throws an error,

XXt threw exception:  System.InvalidOperationException: Can't perform Create, 
Update or Delete operations on 'Table(XXX)' because it has no primary key.

How to use LINQ to insert record in View using C #?

Thanks.

Answer 1

You cannot insert in VIEW. You can only insert a table.

You can do this - see below.

Answer 2

You can insert / update views according to updated views here . Only one base table can be inserted / updated or it will fail. To implement this feature using LINQ, follow these steps:

• .DBML ( )
• , , /, . ;
  • / ;
    • SUM (BaseTable.ColumnName) ColumnName
    • ISNULL (BaseTable.ColumName, 0) ColumnName
    • BaseTable.ColumnName1 + '' + BaseTable.ColumnName2
  • ;
    • BaseTable.ColumnName
    • BaseTable.ColumnName MyNewName
• , .DBML.

. , // .

Answer 3

. , .

, ;

view..in linq sql. ( linq ).

. , . .

Answer 4

, VIEW LINQ to SQL. , , : .

primarykey .

.dbml , , F4 ( ).

true .

. .

Answer 5

'OnInsert' dbml.

Answer 6

, , , , . .

Having said that, L2S requires that your tables have primary keys, as indicated by the error message. After creating the primary key and updating your .DBML accordingly, you should be fine.

Randy