110,534
社区成员
发帖
与我相关
我的任务
分享
public List<object> Query(string @namespace, string table, string where)
{
using (var ctx = new VisualRMIDBEntities())
{
var type = typeof(VisualRMIDBEntities);
var elementType = Type.GetType(string.Format("{0}.{1}", @namespace, table));
var mi = type.GetMethod("ExecuteStoreQuery", new Type[] { typeof(string), typeof(object[])});
mi = mi.MakeGenericMethod(elementType);
var sql = string.Format("select * from {0} where {1}", table, where).Trim();
if (sql.EndsWith("where"))
sql = sql.Replace("where", "");
var result = mi.Invoke(ctx, new object[] { sql, null }) as IEnumerable<object>;
return result.ToList();
}
}
public IEnumerable<object> Query(string @namespace, string table, string where)
{
using (var ctx = new XXXEntities())
{
var type = typeof(XXXEntities);
var elementType = Type.GetType(string.Format("{0}.{1}", @namespace, table));
var mi = type.GetMethod("ExecuteStoreQuery", new Type[] { typeof(string), typeof(object[])});
mi = mi.MakeGenericMethod(elementType);
var sql = string.Format("select * from {0} where {1}", table, where).Trim();
if (sql.EndsWith("where"))
sql = sql.Replace("where", "");
return mi.Invoke(ctx, new object[] { sql, null }) as IEnumerable<object>;
}
}
var result = Query("XXX.DB", "Student", null);
foreach (var r in result)
{
var s = r as Student;
。。。
}