Question

I m new to c# Windows Form Application and I m having a problem in adding/inserting data to SQL DB that has relationship between tables. My question is, Will the relation between the tables function in C# Windows Form Application?

这就是我的行将如何看待。

I m looking for a way to add data to the Article table and Body table where Artcle.body_id will pupolate accordingly. The same as MVC. Thanx

Answer 1

Got the code now. Hope this will help others in the future.

   private void buttonCreateSubmit_Click(object sender, EventArgs e)
    {
        Body body = new Body
        {
            body_content = richTextBoxBody.Text
        };

        tnDBase.AddToBodies(body);
        tnDBase.SaveChanges();

        var genid = tnDBase.Genres.Single(g => g.genre_name == comboBoxGenre.Text);

        Article article = new Article()
        {
            article_name = textBoxTitle.Text,
            genre_id = genid.genre_id,
            status_id = 3,
            body_id = body.body_id
        };

        tnDBase.AddToArticles(article);
        tnDBase.SaveChanges();
     }

Answer 2

您可以确定您更新或插入价值观的习惯方法。

友情链接