blocks|key|1180704|text|使用反射迭代L2S类的属性|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1180705|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Iterate the properties of your L2S classes with reflection

blocks|key|1180785|text|我假设您是指使用LINQ+to+SQL，在这种情况下，请查看DataContext.Mapping属性。我就是这么用的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1180786|如果你不是这个意思，也许你可以详细说明一下你想要实现的目标？|1180787|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.mapping.aspx^0|U|J|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

I assume you mean by using LINQ to SQL, in which case look at the <a href="http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.mapping.aspx" rel="noreferrer">DataContext.Mapping</a> property. That's what I use.

If you don't mean that, perhaps you can elaborate on what you are trying to achieve?

blocks|key|1396300|text|在您的数据上下文中使用ExecuteQuery方法，并执行以下SQL脚本：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1396301|var+columnNames+=+ctx.ExecuteQuery<string>
++++("SELECT+name+FROM+sys.columns+WHERE+object_id+=+OBJECT_ID('your+table+name');");|code-block|syntax|javascript|1396302|这将为您提供一个IEnumerable<string>，其中包含您指定的表中的所有列名。|offset|length|style|CODE|1396303|当然，如果您愿意并且需要的话，您总是可以从SQL+Server中的sys.columns目录视图中检索更多信息(例如，数据类型、最大长度)。|1396304|entityMap^0|0|0|8|J|0|X|B|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@$I|W|J|X|K|L]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

Use the ExecuteQuery method on your data context and execute this SQL script:

<pre><code>var columnNames = ctx.ExecuteQuery&lt;string&gt;
 ("SELECT name FROM sys.columns WHERE object_id = OBJECT_ID('your table name');");
</code></pre>

This gives you an <code>IEnumerable&lt;string&gt;</code> with all the column names in that table you specified.

Of course, if you want and need to, you could always retrieve more information (e.g. data type, max length) from the <code>sys.columns</code> catalog view in SQL Server.

blocks|key|1180946|text|我在寻找同样的东西时偶然发现了这个问题，但在这里并没有看到一个真正好的答案。这就是我想出来的。只需在C#表达式模式下将其放入LINQPad即可。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1180947|from+t+in+typeof(UserQuery).GetProperties()
where+t.Name+==+"Customers"
from+c+in+t.GetValue(this,null).GetType().GetGenericArguments()[0].GetFields()
select+c.Name|code-block|syntax|javascript|1180948|按您认为合适的方式修改。|1180949|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I stumbled upon this question looking for the same thing and didn't see a really good answer here. This is what I came up with. Just throw it into LINQPad under C# expression mode.

<pre><code>from t in typeof(UserQuery).GetProperties()
where t.Name == "Customers"
from c in t.GetValue(this,null).GetType().GetGenericArguments()[0].GetFields()
select c.Name
</code></pre>

Modify as you see fit.

blocks|key|1180976|text|也许为时已晚，但是，我通过下面的代码解决了这个问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1180977|var+db+=+new+DataContex();
var+columnNames+=+db.Mapping.MappingSource
++++++++++++++++++++++.GetModel(typeof(DataContex))
++++++++++++++++++++++.GetMetaType(typeof(_tablename))
++++++++++++++++++++++.DataMembers;|code-block|syntax|javascript|1180978|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Maybe It is too late but, I solved this problem by this code

<pre><code>var db = new DataContex();
var columnNames = db.Mapping.MappingSource
 .GetModel(typeof(DataContex))
 .GetMetaType(typeof(_tablename))
 .DataMembers;
</code></pre>

blocks|key|1181016|text|我在LinqPad中使用了以下代码|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1181017|from+t+in+typeof(table_name).GetFields()+select+t.Name|code-block|syntax|javascript|1181018|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I used this code in LinqPad

<pre><code>from t in typeof(table_name).GetFields() select t.Name
</code></pre>

blocks|key|1181040|text|下面的代码将从返回表的所有列名|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1181041|var+columnnames+=+from+t+in+typeof(table_name).GetProperties()+select+t.Name|code-block|syntax|javascript|1181042|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The below code will worked from returns all the column names of the table

<pre><code>var columnnames = from t in typeof(table_name).GetProperties() select t.Name
</code></pre>

blocks|key|1396510|text|++++++++++++var+query+=+from+x+in+DataBase.Table_Name
++++++++++++++++++++++++select+x.Column_Name;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1396511|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code> var query = from x in DataBase.Table_Name
 select x.Column_Name;
</code></pre>

blocks|key|1181097|text|sp_help+'TableName‘|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1181098|从LinqPad+SQL窗口到ms+sql+server的选项|1181099|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

sp_help 'TableName'

An option for a LinqPad SQL window to ms sql server

blocks|key|1181142|text|在LinqPad中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1181143|TableNames.Take(1)有效。|1181144|它打字速度很快。(尽管您处于理想状态，但最好不要选择任何行。)|1181145|注意，它是TableName的复数形式。您还可以执行Take(0)并查看SQL+results选项卡。|1181146|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

In LinqPad:

TableNames.Take(1) works.

It is fast to type. (Although you in an ideal world, it would be nicer to not select any rows.)

Note it is the pluralized form of TableName. You can also do Take(0) and look at the SQL results tab.

blocks|key|1181182|text|我使用的是.net+Core3.0，这些解决方案对我来说都不起作用。我的解决方案是使用Newtonsoft+Json序列化程序的暴力强制方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1181183|var+dt+=+this._context.Prodmats.First();++//+get+the+first+row+of+my+table

var+json+=+JsonConvert.SerializeObject(dt);++
+
var+tva2+=+new+string(json.Where(c+=>+char.IsLetter(c)+%7C%7C+char.IsDigit(c)+%7C%7C+c+==+':'+
++++++++++++++++++++++++%7C%7C+c+==+','+%7C%7C+char.IsWhiteSpace(c)+).ToArray())++;

++++++++var++arr+=+tva2.Split(',');

++++++++var+col+=+new+List<string>();

++++++++foreach+(var+val+in+arr)
++++++++{+
++++++++++var+ch+=+val.Split(':');
+++++++++++
++++++++++var+trimCh+=+ch[0];+++++++++++++++
++++++++++col.Add(trimCh.Trim());
++++++++}|code-block|syntax|javascript|1181184|//+col+<=有列列表|1181185|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I am using .net core 3.0 and none of these solutions worked for me. My solution was a brute forced approach using Newtonsoft Json serializer.
<pre><code>var dt = this._context.Prodmats.First(); // get the first row of my table

var json = JsonConvert.SerializeObject(dt); 
 
var tva2 = new string(json.Where(c =&gt; char.IsLetter(c) || char.IsDigit(c) || c == ':' 
 || c == ',' || char.IsWhiteSpace(c) ).ToArray()) ;

 var arr = tva2.Split(',');

 var col = new List&lt;string&gt;();

 foreach (var val in arr)
 { 
 var ch = val.Split(':');
 
 var trimCh = ch[0]; 
 col.Add(trimCh.Trim());
 }
</code></pre>
// col &lt;= has the columns list

Using LINQ, how can I get the column names of a table? C# 3.0, 3.5 framework

LINQ: Get Table Column Names

SQL Server

使用LINQ，我如何获得一个表的列名？C# 3.0、3.5框架

问LINQ:获取表列名称
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问LINQ:获取表列名称EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问LINQ:获取表列名称
EN