Question

我比较新,不了解如何做类似情况。我有一份我的目标清单,希望像我的目标那样做。说明如帮助%。我如何能够做到这一点? 增编

Answer 1

参看:

http://blogs.microsoft.co.il/blogs/bursteg/archive/2007/10/16/linq-to-sql- similar-operator.aspx”rel=“nofollow noreferer”>http://blogs.microsoft.co.il/blogs/bursteg/archive/2007/10/16/linq-to-sql- similar-oper.aspx

Snippet:

www.un.org/Depts/DGACM/index_spanish.htm

var query = from c in ctx.Customers
            where c.City.StartsWith("L") && c.City.Contains("n")
            select c;

如果你使用LINQ至Q(不与LINQ接触到物体):

习俗LIKE (System.Data.Linq.SqlClient.SqlMethods.Like):

var query = from c in ctx.Customers
            where SqlMethods.Like(c.City, "L_n%")
            select c;

Answer 2

通常,你在问询之外使用同样的yn。

myObject.Description.StartsWith("Help")

这是否实际奏效,取决于您是否重新使用准则(它可能要么是作为法典,在这种情况下,一切都会奏效,要么被转换成像其他东西,例如可能具有局限性),但总是值得尝试。

Answer 3

http://msdn.microsoft.com/en-us/library/system.string.starts with.aspx” rel=“nofollow noreferer”>StartsWith,,或

var result = from o in myCollection
             where o.Description.StartsWith("Help")
             select o;

您可以选择性地通过“努力委员会”,具体阐明是否无视案件(<条码>,StartsWith和 EndsWith),从而使其运作更加像是结构问题:

var result =
    from o in myCollection
    where o.Description
        .StartsWith("Help", StringComparison.InvariantCultureIgnoreCase))
    select o;

如果你想做一个不敏感的案件,那么你需要使用 IndexOf,而:

var result = 
    from o in myCollection
    where o.Description
        .IndexOf("Help", StringComparison.InvariantCultureIgnoreCase) > 0
    select o;

Answer 4

you can use string.StartsWith or string.EndsWith or string.Contains property of string to use it as Like Operator.
Startswith will work for Like A%
Endswith will work for Like %A
Contains will work like %A%

友情链接