DB lib to convert classes into a scheme and auto generate some queries?

Question

Hey i am looking for a lib that can take the class below and generate these two tables with a reference/foreign key and allow me to tweak the default logic. Like below, unless i specify otherwise when i do sqlClass.Insert(imglist) it will not create another entry for user_id but try to find an existing one in the database.

    class image_list
    {
        public PK id;
        [InsertOrSelect]
        public name_list user_id;
        public long pic_id;
        public string link;
    }
    class name_list
    {
        public PK id;
        public UniqueString username;
    }

Answer 1

If you design your tables using the LINQ-to-SQL ORM you can use the generated DataContext object to create a database containing the schema you designed. The method is called DataContext.CreateDatabase