WCF 服务中的 Linq To SQL 对话

Question

您能否在SQL查询后向linq提供答案。我对linq有一些了解，但我对sql阅读器对象感到困惑..

 public AccountBalanceRequest AccountBalanceCheek(AccountBalanceRequest accountNumber)
    {
        using (SqlConnection conn = new SqlConnection(ConnectionString))
        {
            conn.Open();
            var cmd = new SqlCommand("SELECT  Account_Type,Account_Fees,Account_Balance,Over_Draft_Limit FROM Current_Account_Details WHERE Account_Number = '" + accountNumber.Account_Number + "'", conn);
            cmd.CommandType = CommandType.Text;
            var reader = cmd.ExecuteReader();
            //read the result of the execute command.
            while (reader.Read())
            {
                //assuming that your property is the same as your table schema. refer to your table schema Current_Account_Details
                accountNumber.Account_Type = reader["Account_Type"].ToString();
                accountNumber.Account_Fee = reader["Account_Fees"].ToString();
                accountNumber.Account_Balance = reader["Account_Balance"].ToString();
                accountNumber.Over_Draft_Limit = reader["Over_Draft_Limit"].ToString();
            }
            return accountNumber;
        }
    }

Answer 1

首先，您必须拥有 DbContext，您必须使用它进行实例化（通常的做法）：

using (DbContext db = new DbContext())
{
    var results = (from ad in db.Current_Account_Details
                  where ad.Account_Number == accountNumber.Account_Number
                  select ad).ToList();
}

确保已从数据库创建对象数据模型。

我没有得到你帖子的另一部分，但这将是如何编写 Linq2Entities 查询的一般想法。