Comments by hamid-shrk (Top 16 by date)

I put it:
public IQueryable<simcardoutput> GetSimCardBySearch(string number)
{
var context = new Entities();
var simcard = context.SimCards;
var operators = context.Operators;
var rondtype = context.RondTypes;
var city = context.Cities;
Regex rr = new Regex(number.Replace("*", @"\d"));
var query = from s in simcard
join o in operators on s.IdOperatorFK equals o.IdOperator
join r in rondtype on s.IdRondTypeFK equals r.IdRondType
join c in city on s.IdCityFK equals c.IdCity
where
rr.Match(s.Number).Success
select new SimCardOutPut()
{
IdSimCard = s.IdSimCard,
Operator = o.Title,
RondType = r.Title,
City = c.Title,
Number = s.Number,
Type = s.Type,
Status = s.Status,
Quality = s.Quality,
Seller = s.Seller,
Price = (Int64)s.Price,
ShowType = s.ShowType,
Active = (Boolean)s.Active
};
return query;
}
and the result was:
LINQ to Entities does not recognize the method 'System.Text.RegularExpressions.Match Match(System.String)' method, and this method cannot be translated into a store expression.