Entity SQL Anonymous type?

Question

I have a database with 2 tables :

Personal : ID (PK), Name, Code (FK), Birthdate
Social : Code (PK), Address

When I add a ADO.NET Entity Data Model name Model to my project. The Model.Context.tt has only Personals and Socials Dbset<>, so i can only choose 2 tables by using query :

string sql = "SELECT VALUE p FROM SqlEntities.Personals AS p"

SqlEntities is my entity name, so the thing i want is how to make a column in table become the Dbset<>, maybe I don't understand much but how i can use the anonymous type like :

stringsql = "SELECT p.ID, p.Name FROM SqlEntities.Personals AS p"

Because in Enitty Framework has LINQ and Entity SQL. So I tagged it, if you know solution for my post, you can answer. Thank you ! — Bùi Lê Minh, Oct 31 '15 at 05:59

score 0 · Answer 1 · answered Oct 31 '15 at 06:17

0

With projection, it is possible to make the query return only some columns from one table, or to return selected columns from multiple tables joined together. Projection is done with the Select() method and supports anonymous types:

db.Personals.Select(x => new { ID = x.ID, Name = x.Name });

answered Oct 31 '15 at 06:17

Martin Staufcik

8,295
4
44
63

It's work, thank a lot. But the code you post is belong to LINQ or Entity SQL ? Sorry, I have a bad knowledge about this. – Bùi Lê Minh Oct 31 '15 at 06:43
You are welcome. The Select method belongs to LINQ, and is in all LINQ-to-something technologies (including LINQ-to-SQL). – Martin Staufcik Oct 31 '15 at 06:46
Thanks for your explaning, but I wonder if there is any way to select a column like that but use the query string in ESQL ? – Bùi Lê Minh Oct 31 '15 at 06:49

Entity SQL Anonymous type?

1 Answers1