private static string GenerateQuery(string query, MetadataWorkspace workspace, params EntityParameter[] entityParameters)
{
var entityCommand = new EntityCommand();
entityCommand.CommandText = query;
var connection = new EntityConnection(workspace, new SqlConnection());
entityCommand.Connection = connection;
entityCommand.Parameters.AddRange(entityParameters);
var command = entityCommand.ToTraceString();
foreach (var entityParameter in entityParameters)
{
entityCommand.Parameters.Remove(entityParameter);
}
return(command);
}
public void Test()
{
string con = "name = EmptyModelContainer";
using (EntityConnection econn = new EntityConnection(con))
{
string esql = "Select VALUE c from EmptyModelContainer.Teacher as c where c.CustomerID='ALFKI'";
econn.Open();
EntityCommand ecmd = new EntityCommand(esql, econn);
EntityDataReader ereader = ecmd.ExecuteReader(CommandBehavior.SequentialAccess);
if (ereader.Read())
{
Console.WriteLine(ereader["CustomerID"]);
}
Console.WriteLine(ecmd.ToTraceString());
}
}