how to insert using linq to entity foreign key value?

Posted by Gamble on Stack Overflow See other posts from Stack Overflow or by Gamble
Published on 2010-05-02T22:14:35Z Indexed on 2010/05/02 22:17 UTC
Read the original article Hit count: 403

Filed under:

linq-to-entities

I have a table (TestTable) for example:

ID
Name
Parentid (FK)

and I would like to insert a new record like ID(1) Name(Test) ParentID(5) FK. How can insert a new record into TestTable with linq to entity?

var testTable = new TestTable();
testTable.ID = 1;
testTable.Name = "TestName";
testTable ...

thank you for the working example.

Related posts about linq-to-entities

HELP: deploying applications that use LINQ to Entities.

as seen on Stack Overflow - Search for 'Stack Overflow'
HI COMUNITY!!!! I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error: specified store provider cannot be found in the configuration… >>> More
LiNQ to Entities, Include less

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, If you are making a LinQ to entities expression for ClassA where A has a relation to ClassB like this: var temp = from p in myEntities.ClassA.Include("ClassB") where ... select p; You will get a set of ClassA:s with the reference to ClassB loaded. The thing in my case… >>> More
Linq to Entities : using ToLower() on NText fields

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using SQL Server 2005, with a case sensitive database.. In a search function, I need to create a Linq To Entities (L2E) query with a "where" clause that compare several strings with the data in the database with these rules : The comparison is a "Contains" mode, not strict compare : easy as… >>> More
deploying applications that use LINQ to Entities.

as seen on Stack Overflow - Search for 'Stack Overflow'
HI COMUNITY!!!! I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error: specified store provider cannot be found in the configuration… >>> More
LINQ To Entities - Items, ItemCategories & Tags

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi There, I have an Entity Model that has Items, which can belong to one or more categories, and which can have one or more tags. I need to write a query that finds all tags for a given ItemCategory, preferably with a single call to the database, as this is going to get called fairly often. I currently… >>> More

Developer IT

how to insert using linq to entity foreign key value? - Developer IT

how to insert using linq to entity foreign key value?

linq-to-entities

Related posts about linq-to-entities

HELP: deploying applications that use LINQ to Entities.

LiNQ to Entities, Include less

Linq to Entities : using ToLower() on NText fields

deploying applications that use LINQ to Entities.

LINQ To Entities - Items, ItemCategories & Tags

Categories cloud