C# SubSonic SQLite: NullReferenceException on Update

csqlitesubsonic3

I have seen some older posts similar to this, but I seem to be getting this using SQLite rather than SQL Server.

I think the version is 3.0.0.3.

I am doing an update on an object, in this particular case, the object is passed into a form and saved there…Save() method to repository is on the same class. I have checked the properties before the update and all seems ok? The object is retrieved, a single property updated then the attempt to save.

Error Message:

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

   at SubSonic.Query.Update.GetCommand()

   at SubSonic.Query.Update.Execute()

   at SubSonic.Repository.SimpleRepository.Update[T](T item)

Best Answer

It seems this is a known bug in 3.0.0.3:

See these links:

SubSonic 3.0.0.3 Update Exception http://www.integratedwebsystems.com/2009/11/playing-with-sqlite-subsonic3-and-repository-mode/

Unfortunately I just figured out what "Git" is and now need to see how I can get the source, change it, compile it and use that until a new update is released.

Update:

Downloaded the changes from the updated source indicated in the second link above (integratedwebsystems) This fixed the problem.

As it turns out, downloads from Github are basic zip downloads with all the source and VS projects etc, easily done.

Related Solutions

Sql – How to list the tables in a SQLite database file that was opened with ATTACH

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

SQLite – UPSERT not INSERT or REPLACE

Assuming three columns in the table: ID, NAME, ROLE

BAD: This will insert or replace all columns with new values for ID=1:

INSERT OR REPLACE INTO Employee (id, name, role) 
  VALUES (1, 'John Foo', 'CEO');

BAD: This will insert or replace 2 of the columns... the NAME column will be set to NULL or the default value:

INSERT OR REPLACE INTO Employee (id, role) 
  VALUES (1, 'code monkey');

GOOD: Use SQLite On conflict clause UPSERT support in SQLite! UPSERT syntax was added to SQLite with version 3.24.0!

UPSERT is a special syntax addition to INSERT that causes the INSERT to behave as an UPDATE or a no-op if the INSERT would violate a uniqueness constraint. UPSERT is not standard SQL. UPSERT in SQLite follows the syntax established by PostgreSQL.

GOOD but tedious: This will update 2 of the columns. When ID=1 exists, the NAME will be unaffected. When ID=1 does not exist, the name will be the default (NULL).

INSERT OR REPLACE INTO Employee (id, role, name) 
  VALUES (  1, 
            'code monkey',
            (SELECT name FROM Employee WHERE id = 1)
          );

This will update 2 of the columns. When ID=1 exists, the ROLE will be unaffected. When ID=1 does not exist, the role will be set to 'Benchwarmer' instead of the default value.

INSERT OR REPLACE INTO Employee (id, name, role) 
  VALUES (  1, 
            'Susan Bar',
            COALESCE((SELECT role FROM Employee WHERE id = 1), 'Benchwarmer')
          );

Best Answer

Related Solutions

Sql – How to list the tables in a SQLite database file that was opened with ATTACH

SQLite – UPSERT *not* INSERT or REPLACE

Related Topic

SQLite – UPSERT not INSERT or REPLACE