Linq - 如何在 Linq 中获取查询结果并将其添加到数组中

发布于 2024-10-18 17:19:10 字数 707 浏览 2 评论 0原文

我使用 c#、linq 和 EF4 我想请求你的帮助。

我的问题：我有一个 linq 查询，但我需要将该查询的结果插入到数组字符串中。添加的值应该是 Title 和 ContentId（EF 中的 ContentId 是一个 INT，但我需要它作为字符串）

请让我知道，非常感谢！PS：请发布完整的代码:-)

       public static string[] GetCompletionList(string prefixText, string count)
{
    using (CmsConnectionStringEntityDataModel context = new CmsConnectionStringEntityDataModel())
    {
    var queryTitle = (from content in context.CmsContents
                      select new
                      {
                          Title = content.Title, // String
                          ContentId = content.ContentId.ToString() // Int
                      }).ToArray();
    return queryTitle;


    }

原文

I use c#, linq and EF4 I would like ask your help.

My question:
I have a linq query, but i need the result for this query be inserted in an array string.
Value added should be Title and ContentId (ContentId from EF is an INT but i need it as a string)

Please let me know, many thanks in advances!PS: Please post the full code :-)

       public static string[] GetCompletionList(string prefixText, string count)
{
    using (CmsConnectionStringEntityDataModel context = new CmsConnectionStringEntityDataModel())
    {
    var queryTitle = (from content in context.CmsContents
                      select new
                      {
                          Title = content.Title, // String
                          ContentId = content.ContentId.ToString() // Int
                      }).ToArray();
    return queryTitle;


    }

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

夏日浅笑〃 2024-10-25 17:19:10

如果您希望 ContentId 作为字符串，请执行以下操作：

var queryTitle = (from content in context.CmsContents
                 select new
                 {
                     Title = content.Title, // String
                     ContentId = content.ContentId.ToString() // Int
                 }).ToArray();

queryTitle 将是创建的匿名类型的数组，它有两个属性：

Title
ContentId

均为字符串类型。

如果您不想拥有匿名类型的数组，而是想要一个字符串数组，请使用以下代码：

var queryTitles = (from content in context.CmsContents
                 select "Title: " + content.Title + ", ContentId: " +  content.ContentId.ToString()).ToArray();

If you want to have ContentId as a string, then do this:

var queryTitle = (from content in context.CmsContents
                 select new
                 {
                     Title = content.Title, // String
                     ContentId = content.ContentId.ToString() // Int
                 }).ToArray();

queryTitle will be an array of the anonymous type created, which has two properties:

Title
ContentId

Both of type string.

If you don't want to have an array of the anonymous type, but an array of strings, then use this code:

var queryTitles = (from content in context.CmsContents
                 select "Title: " + content.Title + ", ContentId: " +  content.ContentId.ToString()).ToArray();

回复收藏 0 原文

开始看清了 2024-10-25 17:19:10

如果您希望在一大串字符串中包含 contentID 和 Title（从您的问题来看，听起来像这样，但不是很清楚），您可能想尝试此操作

var resultArray = titlesAsArray
            .Select(a => new[]
                             {
                                 a.ContentId.ToString(), a.Title
                             })
            .SelectMany(x => x).ToArray();

或修改您的原始查询

var resultArray = context.CmsContents.Select(content => new[]
                                 {
                                     content.ContentId.ToString(), content.Title
                                 }).SelectMany(content => content).ToArray();

if you are looking to have contentID and Title in one big array of string (from your question, it sounds like that but not very clear), you might want to try this

var resultArray = titlesAsArray
            .Select(a => new[]
                             {
                                 a.ContentId.ToString(), a.Title
                             })
            .SelectMany(x => x).ToArray();

or to modifiy your original query

var resultArray = context.CmsContents.Select(content => new[]
                                 {
                                     content.ContentId.ToString(), content.Title
                                 }).SelectMany(content => content).ToArray();

回复收藏 0 原文

離殇 2024-10-25 17:19:10

var strings = from content in context.CmsContents
              select string.Format ("{0} {1}",
                  content.ContentId,
                  content.Title
              );

这应该对你有帮助。
请注意，一个常见的误解是您需要一个数组来处理查询结果 - 事实上，您不需要，结果已经是 IEnumerable。如果您确定需要一个数组，只需将查询括在括号中，然后对结果调用 ToArray 扩展方法。

var strings = from content in context.CmsContents
              select string.Format ("{0} {1}",
                  content.ContentId,
                  content.Title
              );

That should help you.
Note that it's a common misconception that you need an array to work with query results—in fact, you don't, the result is already IEnumerable. If you're sure that you need an array, just wrap query in parentheses and call ToArray extension method on the result.

回复收藏 0 原文

~没有更多了~