I'm building a custom addon for a SP 2010 instance. I've been able to get a Visual Web Part in visual studio deployed to my SP instance and debug it. As far as I can tell I have all the normal capabilities that I'd have in as ASP.NET project. Here is my question:
What is the proper way to create my own custom tables to store data specific to my solution? Does SP provide a standardized way to accomplish this? I don't need in-depth details but I'm looking more for best practices to understand how this is done.
Also, I've been able to create my own lists in SP that I can access via code. I've been able to pull them out and see their names. They don't seem to have a corresponding seed value or ID. Again, what is the best practice for referencing these lists? It seems that a user could delete a list item and orphan a ton of records.
Just looking for a push in the right direction.