An unhandled exception occurred while processing the request.

Hi Pierre,

Have you tried adding the [Key] token to your .NET DataStore? (See the [Key] token added to the Primary Key column in the following example)

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using SnapObjects.Data;
using DWNet.Data;
using Newtonsoft.Json;

namespace Appeon.ApiDoc.Models
{
    [DataWindow("d_department", DwStyle.Grid)]
    [Table("Department", Schema = "dbo")]
    #region DwSelectAttribute  
    [DwSelect("PBSELECT( VERSION(400) TABLE(NAME=\"Department\" ) @(_COLUMNS_PLACEHOLDER_) )")]
    #endregion
    [UpdateWhereStrategy(UpdateWhereStrategy.KeyAndConcurrencyCheckColumns)]
    [DwKeyModificationStrategy(UpdateSqlStrategy.DeleteThenInsert)]
    [DwTemplate(DataFormat.Xml, "xml_default", "Templates\\xml_setparameter_default.xml", IsDefault = true)]
    public class D_Department
    {
        [Key]
        [DwColumn("Department", "DepartmentID")]
        public int Departmentid { get; set; }

        [ConcurrencyCheck]
        [DwColumn("Department", "Name")]
        public string Name { get; set; }

        [ConcurrencyCheck]
        [DwColumn("Department", "Budget")]
        public decimal Budget { get; set; }

        [ConcurrencyCheck]
        [DwColumn("Department", "StartDate")]
        public DateTime Startdate { get; set; }

        [ConcurrencyCheck]
        [DwColumn("Department", "Administrator")]
        public int? Administrator { get; set; }

    }

}

Regards,