LINQ to SQL - 查询精确值

发布于 2024-11-07 16:29:54 字数 383 浏览 0 评论 0原文

我有一个查询将检索 number > 15，尽管当我尝试指定一个确切的值时，例如“==“2””，我收到

    DataClasses1DataContext db = new DataClasses1DataContext(); 
    var returnunits15 = from p in db.Products 
            where p.UnitPrice > 15 // If unit price is greater than 15...
            select p; // select entries

错误我如何调整查询以查找精确的字符串，例如“test”

和

精确的值（例如 20）？

原文

I have a query that will retrieve number > 15, although when I try and specify an exact value, for example "== "2"" I get errors

    DataClasses1DataContext db = new DataClasses1DataContext(); 
    var returnunits15 = from p in db.Products 
            where p.UnitPrice > 15 // If unit price is greater than 15...
            select p; // select entries

E.g. how could I adapt the query to look for an exact string e.g. "test"

and

and exact value for example 20.?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

青衫负雪 2024-11-14 16:29:54

UnitPrice 是十进制吗？
不能将数字类型与字符串进行比较。

如果要检查数字类型是否相等，则不需要使用“”引号。

DataClasses1DataContext db = new DataClasses1DataContext(); 
var returnunits15 = from p in db.Products 
        where p.UnitPrice == 20
        select p;

仅需要使用引号进行字符串比较。

UnitPrice is decimal?
You can't compare numeric types with strings.

If you want to check for equality for numeric types, you don't need to use "" quote marks.

DataClasses1DataContext db = new DataClasses1DataContext(); 
var returnunits15 = from p in db.Products 
        where p.UnitPrice == 20
        select p;

You need to use quote marks for string comparison only.

回复收藏 0 原文

~没有更多了~