Linq To Sql Insert Issue

Question

I am using Linq To Sql to insert few data to a table in Sql server 2008.

            memadd.add_id = Convert.ToDecimal(resadd);
            memadd.mem_add = txtResAdd.Text;
            memadd.tel_no1 =Convert.ToDecimal(txtResTelNo.Text);
            memadd.mob_no1 = Convert.ToDecimal(txtResMobNo.Text);
            memadd.state = drpResState.Text;
            memadd.city = drpResCity.Text;
            memadd.pin_no = Convert.ToDecimal(txtResPinNo.Text);
            dt.mem_addresses.InsertOnSubmit(memadd);
            dt.SubmitChanges();

My issue here is that when i insert data into the field , it gives me an error saying

Can't perform Create, Update or Delete operations on 'Table(mem_address)' because it has no primary key.

I have a situation wherein i cant set primary key to that table .Can anyone please point me out what needs to be done here. Thanks

Why is it that you can't set a primary key?

Wouter de Kort
– Wouter de Kort ♦

2012-03-12 08:42:06 +00:00
Commented Mar 12, 2012 at 8:42 — Wouter de Kort
– Wouter de Kort ♦, Commented Mar 12, 2012 at 8:42

leppie · Accepted Answer · 2012-03-12 08:42:57Z

1

Just tell the memadd table in the DBML designer to select add_id as a PK for example.

It needs not be on the database itself.

answered Mar 12, 2012 at 8:42

leppie

118k18 gold badges201 silver badges300 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Priyank Patel Over a year ago

if i do that the add_id is going to be repeated like 1,2,3 then again 1,2,3 ,,, so do you think it would be feasible , doing that wont create problems ????

leppie Over a year ago

@freebird: Make it a composite key then to find some form of uniqueness.

Priyank Patel Over a year ago

,, can i set add_id as primary key in the designer and carry on or i should proceed as you suggested.. I dont know how to make it composite key.

leppie Over a year ago

@freebird: Just select both columns.

Alex · Accepted Answer · 2012-03-12 08:42:08Z

1

Linq to sql can't be used in such situations. Just warp your insert statement into a stored procedure and add the procedure to your data model. If you can't do that, write a normal function with a bit of in-line SQL

answered Mar 12, 2012 at 8:42

Alex

6,20913 gold badges46 silver badges81 bronze badges

1 Comment

leppie Over a year ago

IIRC, I had no problem providing Linq2SQL with a 'pseudo' PK.

Aleksej Vasinov · Accepted Answer · 2012-03-12 08:43:48Z

1

Linq does not support table w/o primary keys...

answered Mar 12, 2012 at 8:43

Aleksej Vasinov

2,80730 silver badges29 bronze badges

Collectives™ on Stack Overflow

Linq To Sql Insert Issue

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related