Linq to SQL:等效的DataTable.Rows [0] ["ColumnName"]] [英] Linq to SQL: DataTable.Rows[0]["ColumnName"] equivalent

问题描述

考虑一下:

var query = from r in this._db.Recipes
            where r.RecipesID == recipeID
            select new { r.RecipesID, r.RecipesName };

如何在不使用for循环的情况下在query对象中获取各个列?​​

How would i get individual columns in my query object without using a for-loop?

基本上:如何将DataTable.Rows[0]["ColumnName"]转换为Linq语法?

Basicly: how do I translate DataTable.Rows[0]["ColumnName"] into Linq syntax?

推荐答案

这是解决问题的方法:

DataContext dc = new DataContext();

var recipe = (from r in dc.Recipes 
              where r.RecipesID == 1
              select r).FirstOrDefault();

if (recipe != null)
{
    id = recipe.RecipesID;
    name = recipe.RecipesName;
}

这篇关于Linq to SQL:等效的DataTable.Rows [0] ["ColumnName"]]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！