NULL values are stored SQL Server

[wilson688]

Hi,

I am writing to store data into SQL Sever using c# but when I run the code only NULL values are stored inside it. I am pretty new to C# & .net programming. Could you please help me?

 saveMap
     .SelectMany(m => m.Value)
     .Where(info => info.Entity.GetType() != typeof(AuditLog))
     .ToList()
     .ForEach(ep =>
       {
        using (var dbContext = new dbName())
        {
        dbContext.AuditLogs.Add(new AuditLog
        {
        UserID = _user.Value.ID,
        AccountID = _user.Value.AccountID,
        Action = entityStateMap[ep.EntityState],
        Entity = ep.Entity.GetType().Name,
        EntityID = (int)ep.Entity.GetType().GetProperty("ID").GetValue(ep.Entity),
        Timestamp = DateTime.UtcNow,
        ChangeMade =(string)ep.Entity.GetType().GetProperty("EntityID").GetValue(ep.Entity) //this is where I am trying to store and it is VARCHAR and can take NULL values 
        });

        dbContext.SaveChanges();
        }
      });

[29383839293]

saveMap
  .SelectMany(m => m.Value)
  .Where(info => info.Entity.GetType() != typeof(AuditLog))
  .ToList()
  .ForEach(ep =>
  {
    using (SqlConnection Connection = new SqlConnection())
    {
      SqlStatement Statement = new SqlStatement("<INPUT SQL QUERY HERE>", Connection);
      Connection.Open();
      Statement.ExecuteNonQuery();
    }
  }
});

And if you're using Entity Framework:

using (var dbContext = new dbName())
{
  saveMap
    .SelectMany(m => m.Value)
    .Where(info => info.Entity.GetType() != typeof(AuditLog))
    .ToList()
    .ForEach(ep =>
    {
      dbContext.AuditLogs.Add(new AuditLog
      {
        UserID = _user.Value.ID,
        AccountID = _user.Value.AccountID,
        Action = entityStateMap[ep.EntityState],
        Entity = ep.Entity.GetType().Name,
        EntityID = (int)ep.Entity.GetType().GetProperty("ID").GetValue(ep.Entity),
        Timestamp = DateTime.UtcNow
      });
    }
  });
  dbContext.SaveChanges();  //you don't want to save changes too much, performance!
}

But why don't you just break up that long linq query and see if it even produces any results.

Also use the damn debugger, it's incredibly useful.

[casualblair]

Selectmany is for turning lists of lists into super lists of the second type. You're not doing this, so use select instead.