Subsonic 3 - Update NullReferenceException

Question

I am using Subsonic v3.0.0.3 with the Linq templates. I am attempting to update a record in a SQL Server Express database with the following:

var db = new MyDB(Constants.Database);
db.Update<Contact>()
  .Set(d => d.FirstName == contact.FirstName)
  .Where(d => d.Id == contact.Id)
  .Execute();

I am receiving a NullReferenceException when this line is executed. The stack trace is as follows:

   at SubSonic.Query.Update.GetCommand()
   at SubSonic.Query.Update.Execute()

Any chance that someone may be able to suggest what the problem is?

Answer 1

Hmm - I would say to make sure the connection string is present (I'll be fixing the error message for missing connection strings in the coming weeks) other than that - this looks like an issue - would you mind posting at Github?

Answer 2

I get the same issue. It it fixed?

BTW:I use SimpleRepository pattern.

Order order = repo.Single(c=>c.OrderID=orderid); order.ModifiedDate = DateTime.Now; repo.Update(order);

The exception is thrown when excute the update.

Answer 3

Same issue, only with update. All querying, deleting and adding works.

[NullReferenceException: La référence d'objet n'est pas définie à une instance d'un objet.] SubSonic.Query.Update.GetCommand() +352 SubSonic.Query.Update.Execute() +13 SubSonic.Repository.SimpleRepository.Update(T item) +162

Answer 4

Same issue here. Using ActiveRecord.

Can anybody tell us how to rectify this issue in the meanwhile?

Answer 5

Same issue here. Using ActiveRecord. waite For 3.0.0.4 ！ Thanks！

Answer 6

Same problem with repo.Update(o);

Answer 7

Same Issue with repo.Update()

Stacktrace:

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

Answer 8

I did a simple update which give me an NullReferenceException FarmDB db = new FarmDB(); db.Update().Set(x => x.phone == "13679178184").Where(x => x.name == "marship").Execute();

After step into the code, I found the line in Query/update.cs L186 internal Setting CreateSetting(IColumn column, bool isExpression) { Setting s = new Setting { query = this, ColumnName = column.Name, ParameterName = (provider.ParameterPrefix + "up" + column.Name), IsExpression = isExpression, DataType = column.DataType };

The ColumnName = column.QualifiedName should be ColumnName = column.Name

After correct this, update runs well. Hope some one can check this.