LINQ返回异常 [英] LINQ return an exception

问题描述

HI ..

当我尝试通过查询下面的linq检索记录时，我正面临异常。

此查询返回多行。如果vehicle_type_cde在Vehicle_type_codes表中不存在，并且此查询返回null，则会引发异常，如何停止引发异常？

 

    var objQuery = PGS_Connection.DBObjectForRetrieval.VEHICLE_TYPE_CODES

                    .Where（w =>（w.vehicle_type_cde.Contains（" 00001"）|| w.vehicle_type_cde.Contains（" 00002"）|| w.vehicle_type_cde.Contains（" 00011"）））

                   .Select（s => new {s.vehicle_type_cde，s.vehicle_type_dsc}）;

---

maifs

解决方案

< p style ="margin：0in 0in 0pt"> Maifs，

 

是否可以提供正在抛出的异常的详细信息，包括堆栈跟踪。

 

谢谢，

亚瑟

HI..

i am facing an exception when i try to retrieve records through linq below query.

This query returns mutiple rows . IF vehicle_type_cde doesn't exist in Vehicle_type_codes tables and this query returns null then an exception will be raised how can i stop to raising an exception?

 

    var objQuery = PGS_Connection.DBObjectForRetrieval.VEHICLE_TYPE_CODES
                   .Where(w => (w.vehicle_type_cde.Contains("00001") || w.vehicle_type_cde.Contains("00002") || w.vehicle_type_cde.Contains("00011")))
                   .Select(s => new { s.vehicle_type_cde, s.vehicle_type_dsc });

---

maifs

解决方案

Maifs,

 

Can you provide details of the exception that is being thrown, including a stack trace.

 

Thanks,

Arthur

这篇关于LINQ返回异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！