Database Management Systems

This class is about Database Management Systems. As such we talk about creating, managing and programming SQL databases. When time permits, we also cover spatial/spatial temporal data and database systems. This site contains content developed by Dr. Anderson for his classes.

Programming Examples

• Lecture 1

  • Commandline Connected Example

  • Forms Disconnected Example

• Look at the Objects we use

  • DataSet Class

  • Filled by TableAdapter

  • BindingSource as a service provider

    • How are GUI elements bound then?
    • How do the GUI elements change?

  • BindingNavigator

Programming Resources

Learning to program something more complex than a one off programming assignments for students can be difficult. Where do the experts learn to program large database applications and what tools and methods do they use? This section is not an answer, but a suggestion on where to look for those answers. Someday, I hope to have a class that explores this in depth.

• Domain Driven Design has an entire website to look at: http://domaindrivendesign.org/

• NHibernate: http://nhibernate.org

• Naked Entites/Objects (http://www.nakedobjects.com) is a for pay framework

• CSLA.NET

• SpecExpress http://specexpress.codeplex.com

And many more to follow I'm sure.