I have 7 errors on this and it doesn\'t seem to connect to my SQL database even

ID: 3857362 • Letter: I

Question

I have 7 errors on this and it doesn't seem to connect to my SQL database even though I went in to VS and added data source. It's supposed to be a web adressbook with SQL database.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Runtime.Serialization;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace CustomerContact
{
    public partial class Contacts : Form
    {
        public Contacts()
        {
            InitializeComponent();
        } // End constructor

// Entity Framework DbContext
private AddressExample.AddressBookEntities dbcontext = null;

        // fill our addressBindingSource with all rows, ordered by name
        private void RefreshContacts()
        {
            // Dispose old DbContext, if any
            if (dbcontext != null)
                dbcontext.Dispose();

// create new DbContext so we can reorder records based on edits
dbcontext = new AddressExample.AddressBookEntities();

            //use LINQ to order the Addresses table contents by last name, then first name
            dbcontext.Addresses
                .OrderBy(entry => entry.LastName)
                .ThenBy(entry => entry.FirstName)
                .Load();

            // specify DataSource for AddressBindingSource
            addressBindingSource.DataSource = dbcontext.Addresses.local;
            addressBindingSource.MoveFirst(); // go to first result
            findTextBox.Clear(); // clear the Find TextBox
        } // End method RefreshContacts

        // when the form load, fill it with data from the database
        private void Contacts_Load( object sender, EventArgs e )
        {
            RefreshContacts(); // fill binding with data from database
        } // end method Contacts_Load

        // click event handler for the Save Button in the BlindNavigator saves the changes made in the data
        private void addressBindingNavigatorSaveItem_Click(
            object sender, EventArgs e )
        {
            Validate(); // validate input fields
            addressBindingSource.EndEdit(); // complete current edit, if any try to save changes

            try
            {
                dbcontext.SaveChanges(); // write changes to database
            } // end try
            catch ( DbEntityValidateException )
            {
                MessageBox.Show("Columns cannot be empty, Entity Validation Exception");
            } // end catch

RefreshContacts(); // change back to intial unfiltered data
} // end method addressBindingNavigatorSaveItem_Click

        [Serializable]
        private class DbEntityValidateException : Exception
        {
            public DbEntityValidateException()
            {
            }

            public DbEntityValidateException(string message) : base(message)
            {
            }

            public DbEntityValidateException(string message, Exception innerException) : base(message, innerException)
            {
            }

            protected DbEntityValidateException(SerializationInfo info, StreamingContext context) : base(info, context)
            {
            }
        }

        private class addressBindingSource
        {
            internal static object DataSource;

            internal static void EndEdit()
            {
                throw new NotImplementedException();
            }

            internal static void MoveFirst()
            {
                throw new NotImplementedException();
            }
        }

        private class findTextBox
        {
            internal static void Clear()
            {
                throw new NotImplementedException();
            }
        }
    }
}

I got it down to three errors now:

Severity

Code

Description

Project

File

Line

Suppression State

Error

CS1061

'object' does not contain a definition for 'OrderBy' and no extension method 'OrderBy' accepting a first argument of type 'object' could be found (are you missing a using directive or an assembly reference?)

CustomerContact

Active

Severity

Code

Description

Project

File

Line

Suppression State

Error

CS1061

'object' does not contain a definition for 'local' and no extension method 'local' accepting a first argument of type 'object' could be found (are you missing a using directive or an assembly reference?)

CustomerContact

Active

Severity

Code

Description

Project

File

Line

Suppression State

Error

CS0246

The type or namespace name 'Form1' could not be found (are you missing a using directive or an assembly reference?)

CustomerContact

Active

Severity

Code

Description

Project

File

Line

Suppression State

Error

CS1061

CustomerContact

Active

michlamscolETM E-tire Sul.tiun Team Expiorer Addto Source lype here to search

Explanation / Answer