LINQ select statement gives NullReferenceException

Asked Jun 02 '16 at 13:16

Active Jun 02 '16 at 13:16

Viewed 48 times

I have made a simple view in SQL and I need this transferred to C#. Firstly, I made a LINQ to SQL class. From the SQL Server Object Explorer, I drag-and-dropped the view into the .dbml designer. Then calling the select statement, like so:

var list = from test in testDB.v_TestView select test;

When running this command, I get the following error:

NullReferenceException: Object reference not set to an instance of an object

I'm not quite sure why this simple select statement is bothering me?

Here's the view I made:

CREATE VIEW [dbo].[v_TestView]
    AS select * from TestTable

asked Jun 02 '16 at 13:16

Detilium

2,868
9
30
65

1

Did you happen to notice if `testDB` is null? Where is `testDB` instantiated? – 15ee8f99-57ff-4f92-890c-b56153 Jun 02 '16 at 13:19
if `v_TestView` is in the .dbml file, then you just call the view. `var list = from test in v_TestView select test;` – Kramb Jun 02 '16 at 13:39

LINQ select statement gives NullReferenceException

0 Answers0