siolishe
دوشنبه 12 بهمن 1394, 13:32 عصر
سلام
دوستان کسی میتونه در رابطه با تبدیل کد زیر به Entity کمکم کنه؟
[WebMethod]
public static string[] GetCase(string prefix)
{
List<string> customers = new List<string>();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["ProjectConnectionString"].ConnectionString;
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "select CaseName from Cases where CaseName like @SearchText + '%'";
cmd.Parameters.AddWithValue("@SearchText", prefix);
cmd.Connection = conn;
conn.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
customers.Add(string.Format("{0}", sdr["CaseName"]));
}
}
conn.Close();
}
}
return customers.ToArray();
}
دوستان کسی میتونه در رابطه با تبدیل کد زیر به Entity کمکم کنه؟
[WebMethod]
public static string[] GetCase(string prefix)
{
List<string> customers = new List<string>();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["ProjectConnectionString"].ConnectionString;
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "select CaseName from Cases where CaseName like @SearchText + '%'";
cmd.Parameters.AddWithValue("@SearchText", prefix);
cmd.Connection = conn;
conn.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
customers.Add(string.Format("{0}", sdr["CaseName"]));
}
}
conn.Close();
}
}
return customers.ToArray();
}