The FirstOrDefault extension method work properly but it aways perform a sql query with no where clausule in database returning all records!
Thanks,
Vitor
Why FirstOrDefault method aways gets all records from database?
Hot Topic
- 2 Patterns for single Crystal Report (rpt) file
- How can I determing local path for pictures in XAML?
- MSDN (or MS Document Explorer) crashing like crazy
- Cannot debug a form method called from a thread
- Running WBA in an IFrame
- Deployment error with CR XI R2 on Windows Server
- VSTO 2005 Upgrade did not install Visual Web Developer
- A Software Factory Newbie Wants To Undersand Some Things....
- How can you skip the UI when you run a recipe?
- GridView representation of XML
Visual Studio
- AddNamedCommand fails in 2005 beta 2
- Retrieve the test deployment folder..
- Online help doesn't work
- I want to get the project name on the "New Project" page in VS2005?How to get it ?
- Is Avalon and XAML interoperable between Windows and Web ?
- can Accessing members of the Field Collection By Index?
- how to create and view a 3D model of a "true" object in WPF?
- MouseLeave fires over StackPanel child control's margin
- How to do SQL query on xsd schema file in CR for VS2005?
- How to configure Crystal Reports DB Connectivity Using the Reports as a web service
Why FirstOrDefault method aways gets all records from database?
JoeyRelieved
Pazu
// This performs a SQL clausule with a where clausule
// A exceptions it's returned when no results founded Enterprise enterprise = db.Enterprises.First(e => e.ID == 181);// This performs a SQL clausule with *NO* where clausule
// All database records are internally returned
Enterprise enterprise = db.Enterprises.FirstOrDefault(e => e.ID == 181);// This work ok
Enterprise enterprise = db.Enterprises.Where(e => e.ID == 181).FirstOrDefault();Ekta
Phil Nicholas