FFaw4hQG

1CREATE TABLE IF NOT EXISTS `post` (
2  `postid` int(10) unsigned NOT NULL AUTO_INCREMENT,
3  `userid` int(10) unsigned NOT NULL DEFAULT '0',
4  `pagetext` mediumtext,
5) ENGINE=MyISAM DEFAULT CHARSET=latin1;
6
7CREATE TABLE IF NOT EXISTS `postparsed` (
8  `postid` int(10) unsigned NOT NULL DEFAULT '0',
9  `pagetext_html` mediumtext,
10) ENGINE=MyISAM DEFAULT CHARSET=latin1;
11	
12[Table("post")]
13public class Post{
14    [Key, Column("postid")]
15    public int PostId { get; set; }
16
17    [Column("userid")]
18    public int FromUserId { get; set; }
19
20    [Column("pagetext")]
21    public string PageText{ get; set; },
22
23    public virtual PostParsed Parsed { get; set; }
24}
25
26[Table("postparsed")]
27public class PostParsed {
28    [Column("postid"), Key, ForeignKey("Post")]
29    public int Id { get; set; }
30
31    [Column("pagetext_html")]
32    public string PagetextHtml { get; set; }
33
34    public virtual VBPost Post { get; set; }
35}
36	
37var db = new MyDbContext();
38var post = new Post() {
39                FromUserId = 1,
40                PageText = "Test",
41                Parsed = new PostParsed() {
42                    PageTextHtml = "<b>Test</b>"
43                }
44            };
45            db.Posts.Add(post);
46            db.SaveChanges();