MongoDB数组赋值、NullReferenceException排查与数据读写技术求助

Hey there, let's break down your problems one by one to get you sorted!

1. Troubleshooting System.NullReferenceException #

First, let's tackle that error you're seeing. The System.NullReferenceException (HResult=0x80004003) pops up when you try to access a member (like a property, method, or field) of an object that’s null—meaning it hasn’t been initialized yet.

From your stack trace, the error hits at line 20 in Program.cs. Here's how to diagnose and fix it:

• Step 1: Inspect line 20
  Look at every object you’re using on that line. For example:
  • Did you forget to initialize your MongoClient, database, or collection instance?
  • Are you trying to add items to a Logs or Contacts list that hasn’t been initialized (i.e., it’s still null)?
• Step 2: Add null checks or initialize objects
  Always ensure objects are set up before using them. For example:
  • If you’re working with nested lists like Logs, initialize it in your model class (or right before adding items) to avoid null.
  • Verify your MongoDB collection isn’t null with a quick check:

    if (collection == null) throw new InvalidOperationException("Collection not initialized!");
    

• Common causes in your scenario
  The most likely culprit is either:
  • Your MongoDB collection reference is null (you didn’t properly fetch it from the database), or
  • The Logs/Contacts field in your entity is null, and you’re trying to add items to it without first creating a new list.

2. Assigning Values to Logs/Contacts & Inserting into MongoDB #

First, let’s define a sample model that matches your schema (adjust fields to fit your actual needs):

using MongoDB.Bson;
using MongoDB.Bson.Serialization.Attributes;
using System.Collections.Generic;
using System;

public class LogEntry
{
    public DateTime Timestamp { get; set; }
    public string Message { get; set; }
}

public class ContactInfo
{
    public string FullName { get; set; }
    public string Email { get; set; }
}

public class YourEntity
{
    [BsonId]
    [BsonRepresentation(BsonType.ObjectId)]
    public string Id { get; set; }
    
    // Initialize lists here to avoid null references later
    public List<LogEntry> Logs { get; set; } = new List<LogEntry>();
    public List<ContactInfo> Contacts { get; set; } = new List<ContactInfo>();
}

Now, here’s how to create an instance, populate Logs and Contacts, and insert it into MongoDB:

using MongoDB.Driver;
using System.Threading.Tasks;

class Program
{
    static async Task Main(string[] args)
    {
        // 1. Initialize MongoDB client (replace with your connection string)
        var client = new MongoClient("mongodb://localhost:27017");
        
        // 2. Get your database
        var database = client.GetDatabase("your_database_name");
        
        // 3. Get the collection
        var collection = database.GetCollection<YourEntity>("your_collection_name");
        
        // 4. Create and populate your entity
        var newEntity = new YourEntity
        {
            Logs = new List<LogEntry>
            {
                new LogEntry { Timestamp = DateTime.UtcNow, Message = "User logged in" },
                new LogEntry { Timestamp = DateTime.UtcNow, Message = "Data updated" }
            },
            Contacts = new List<ContactInfo>
            {
                new ContactInfo { FullName = "Alice Johnson", Email = "alice@example.com" },
                new ContactInfo { FullName = "Bob Williams", Email = "bob@example.com" }
            }
        };
        
        // 5. Insert into the database
        await collection.InsertOneAsync(newEntity);
    }
}

Key note: By initializing Logs and Contacts as empty lists in the YourEntity class, you avoid the risk of null references when adding items later.

3. Reading Data from MongoDB (Including Logs & Contacts) #

Here are a few common ways to retrieve documents and access their Logs and Contacts fields:

Read a single document by ID #

var entityId = "your_document_id_here"; // Replace with actual ObjectId string
var filter = Builders<YourEntity>.Filter.Eq(e => e.Id, entityId);
var entity = await collection.Find(filter).FirstOrDefaultAsync();

if (entity != null)
{
    // Access Logs
    Console.WriteLine("Logs:");
    foreach (var log in entity.Logs)
    {
        Console.WriteLine($"{log.Timestamp:yyyy-MM-dd HH:mm:ss} - {log.Message}");
    }
    
    // Access Contacts
    Console.WriteLine("\nContacts:");
    foreach (var contact in entity.Contacts)
    {
        Console.WriteLine($"{contact.FullName} <{contact.Email}>");
    }
}
else
{
    Console.WriteLine("Entity not found.");
}

Read all documents with a specific contact email #

var emailFilter = Builders<YourEntity>.Filter.ElemMatch(e => e.Contacts, c => c.Email == "alice@example.com");
var matchingEntities = await collection.Find(emailFilter).ToListAsync();

foreach (var entity in matchingEntities)
{
    Console.WriteLine($"Entity ID: {entity.Id}");
    // ... access Logs/Contacts as needed
}

内容的提问来源于stack exchange，提问作者AMIT MISHRA