MOSS 2010

MOSS 2007 – Open Source – Collaboration – Web 2.0 – Education

When to use SQL Tables and when to use Lists?

Posted by moss2010 on December 5, 2007

Use Lists, especially with InfoPath forms. Import data including column definitions from MS Access 2007.

Use SQL Tables for ASP.NET applications (and lists for lookups).


One Response to “When to use SQL Tables and when to use Lists?”

  1. Michael said

    Correct me if I am wrong, but the way I was trained on MOSS, is that MOSS developers should steer clear from tables as much as possible, and use lists where ever possible.
    It almost seems like bad practice to use SQL tables, and to query them in a MOSS environment, for any requirement that would fit inside a list. I guess perhaps because the list can be accessed by CAML queries and the MOSS Api, where as SQL tables are only accessible by custom code.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: