Opvullen Access DB (Opgelost)

using (GenericAccessDataSetTableAdapters.UsersTableAdapter userAdapter = new GenericAccessDataSetTableAdapters.UsersTableAdapter())
            {
                // Get the data from the DataTable
                using (GenericAccessDataSet.UsersDataTable users = userAdapter.GetData())
                {
                    Console.WriteLine("GenerateMDB: Removing " + users.Count + " records from [Users]");
                    users.Clear();

                    // Get all contacts where (extranet = true or eNews = true) AND organization != [snip ;-)]
                    Console.WriteLine("GenerateMDB: Retrieve all contacts");
                    var contacts = (
                        from c in XrmContext.contacts
                        where (c.qess_extranet == true || c.qess_enews == true) && c.parentcustomerid.Value != new Guid("DD76B167-0A9E-DF11-A2C1-000C294F6A9A")
                        select c);


                    foreach (var contact in contacts)
                    {
                        // Construct user row
                        GenericAccessDataSet.UsersRow row = users.NewUsersRow();

                        row.UserID = contact.qess_idcontact;
                        
                        // ... enzovoort enzovoort

                        // Add the row
                        users.Rows.Add(row);
                    }

                    // Reinject the data
                    Console.WriteLine("GenerateMDB: Fill [Users]");
                    userAdapter.Fill(users);
                    Console.WriteLine("GenerateMDB: " + users.Count + " written to [Users]");
                }
            }

using (GenericAccessDataSetTableAdapters.UsersTableAdapter userAdapter = new GenericAccessDataSetTableAdapters.UsersTableAdapter())
            {
                // Get the data from the DataTable
                using (GenericAccessDataSet.UsersDataTable users = userAdapter.GetData())
                {
                    Console.WriteLine("GenerateMDB: Removing " + users.Count + " records from [Users]");
                    users.Clear();
 
                    // Get all contacts where (extranet = true or eNews = true) AND organization != [snip ;-)]
                    Console.WriteLine("GenerateMDB: Retrieve all contacts");
                    var contacts = (
                        from c in XrmContext.contacts
                        where (c.qess_extranet == true || c.qess_enews == true) && c.parentcustomerid.Value != new Guid("DD76B167-0A9E-DF11-A2C1-000C294F6A9A")
                        select c);
 
 
                    foreach (var contact in contacts)
                    {
                        // Construct user row
                        GenericAccessDataSet.UsersRow row = users.NewUsersRow();
 
                        row.UserID = contact.qess_idcontact;
 
                        // ... enzovoort enzovoort
 
                        // Add the row
                        users.Rows.Add(row);
                    }
 
                    // Reinject the data
                    Console.WriteLine("GenerateMDB: Fill [Users]");
                    userAdapter.Fill(users);
                    Console.WriteLine("GenerateMDB: " + users.Count + " written to [Users]");
                }
            }