|
static void Main(string[] args)
{
using (EntityConnection cn = new EntityConnection("Name=pubsEntities"))
{
cn.Open();
EntityCommand cmd = cn.CreateCommand();
cmd.CommandText = "SELECT Value c FROM pubsEntities.titles " +
"AS c WHERE c.type = @type";
string type = "business";
cmd.Parameters.AddWithValue("type", type);
EntityDataReader edr = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
while (edr.Read())
Console.WriteLine("{0} - {1}", edr["title_id"], edr["title"]);
edr.Close();
cn.Close();
}
}
|
|