معادل این دستور چیه؟

[aliaghaaaaa]

سلام.
معادل این دستور اس کیو ال تو لینک چیه؟


select name + ' ' + family as 'NAME' from person where id=1

ممنون.

[Mansoor92]

سلام
بفرمایید

var q= from c in db.tbl_user
where c.id==1
select c.name+' '+c.family

[arash_flag]

select 'name' = name+' ' +family from tbl_s where id=1

select [name] = name+ ' ' +family from tbl_s where id=1
موفق باشی

[aliaghaaaaa]

سلام.
من اینطوری نوشتم ولی اررور میده:
چطور بنویسمش؟


var q = from p in db.persons
where (p.Pid.ToString().Substring(0, textBox1.Text.Length) == textBox1.Text)
orderby p.Pid, p.name
select new { p.Pid, p.name +' '+ p.family, p.tell, p.mob };
dataGridView1.DataSource = q;


این هم اررورش:


Error 1 Invalid anonymous type member declarator. Anonymous type members must be declared with a member assignment, simple name or member access.

ممنون.

[ferdin]

سلام

این شکلی بنویس :


var myvar = p.Pid.ToString().Substring(0, textBox1.Text.Length)
var q = from
p in db.persons
where myvar == textBox1.Text)
orderby p.Pid, p.name
select new { p.Pid, p.name +' '+ p.family, p.tell, p.mob };
dataGridView1.DataSource = q;