如何将entityobject作为参数传递给函数 [英] how to pass the entityobject as parameter to function

问题描述

我有3个实体框架连接对象，
IE. 1>实体1 ==用于数据库主数据库
2>实体2 ==用于项目数据库
3>实体3 ==用于本地数据库

如何编写将单列值提供给数据库中的Linq Query的泛型函数.根据数据库类型(实体).

请帮我.

谢谢和问候
vilas jadhav

Hi,

I have 3 entity framework connections objects ,
ie. 1> entity1 == for database Master
2> entity2 == for project database
3> entity3 == for local database

how to write generic function which give the single column value to Linq Query from database. as per database types(entity).

Please help me for this.

Thanks and regards
vilas jadhav

推荐答案

我得到了下面的解决方法

Hi,
I got the solution as bellow

public List<T> getRecored_ByQry<T>(string queryString, string strentityName)
       {
           List<T> lst = new List<T>();
           string dbconName = strentityName;
           if (std_con.DefaultContainerName.ToString() == strentityName)
           {
               //queryString = "SELECT VALUE c FROM " + dbconName + "." + tblName + " as c";
               ObjectQuery<T> contactQuery = std_con.CreateQuery<T>(queryString);
               lst = contactQuery.ToList();
               std_con.Refresh(System.Data.Objects.RefreshMode.StoreWins, contactQuery);
           }
           return lst;
       }

从代码中调用它

call it from code

List<tbl_Project> nlst = new List<tbl_Project>();

        selectQry = "SELECT VALUE User " +
                                " FROM Projects_Entities.tbl_Project " +
                                " AS User WHERE User.str_S_Code ='" + txtProjectCode.Text + "'";

            nlst = getRecored_ByQry<tbl_Project>(selectQry, "Projects_Entities");

这篇关于如何将entityobject作为参数传递给函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！