Question

我的表格有版本编号和版本ID。我需要根据版本编号获得该版本的ID。如何以更有效的方式实现这一目标?

        using (PatchSyncDBDataContext patchSyncDB = new PatchSyncDBDataContext())
        {
            int versionID = (from version in patchSyncDB.AppPM_Versions
                             where version.StatusID != 0 &&
                             version.VersionNumber == versionNumber
                             select version.VersionId).First();

            int customerID = (from reqID in patchSyncDB.MasterRepTables
                              where reqID.rep_email == dtLoginUser
                              select reqID.rep_id).First();

            AppPM_Patch AppPM_Patches = new AppPM_Patch()
            {
                PatchId = patchID,
                IncidentId = incidentID,
                VersionId = versionID,
                RequestedUserId = customerID,
                Emails = emailTo,
                StartDateTime = dateTimes,
                PatchStatus = patchStatus,
                StatusID = 1,
                SelectedProjects = selectedProjects
            };
            patchSyncDB.AppPM_Patches.InsertOnSubmit(AppPM_Patches);
            patchSyncDB.SubmitChanges();
        }

Answer 1

假设这一点,你会问:

int versionID = (from version in patchSyncDB.AppPM_Versions
                 where version.StatusID != 0 &&
                 version.VersionNumber == versionNumber
                 select version.VersionId).First();

我看不出以什么更好的方式来进行询问,你可能会使用<代码>稍加直接的辛迪加。在()和.Select(>推广方法中,但如果你的查询参数为VersionNumber = parm和StatusID ! 0 我看不出对它有更好的询问,但可能还有一种储存程序,即返回代码。

Answer 2

观点

private void button1_Click(object sender, EventArgs e)
    {
        DataClasses1DataContext dc = new DataClasses1DataContext();
        List<Table2> lst = new List<Table2>();
        lst = (from x in dc.Table2s select x).ToList();
        dataGrid观点1.DataSource = lst; 
    }

搜索

private void button2_Click(object sender, EventArgs e)
    {
        DataClasses1DataContext dc = new DataClasses1DataContext();
        List<Table2> lst = new List<Table2>();
        lst = (from x in dc.Table2s where x.Id==1 select x).ToList();
        dataGrid观点1.DataSource = lst;
    }

插入

private void button3_Click(object sender, EventArgs e)
    {
        DataClasses1DataContext dc = new DataClasses1DataContext();
        List<Table2> lst = new List<Table2>();
       dc.InsertTable2(Convert.ToDecimal(textBox1.Text), textBox2.Text, Convert.ToChar(textBox3.Text));
        dc.SubmitChanges();
        lst = (from x in dc.Table2s select x).ToList();
        dataGrid观点1.DataSource = lst;
    }

更新

    private void button4_Click(object sender, EventArgs e)
    {
        DataClasses1DataContext dc = new DataClasses1DataContext();
        List<Table2> lst = new List<Table2>();
        dc.UpdateTable2(2, "a",  F );
        dc.SubmitChanges();
        lst = (from x in dc.Table2s select x).ToList();
        dataGrid观点1.DataSource = lst;
    }

删除

    private void button5_Click(object sender, EventArgs e)
    {
        DataClasses1DataContext dc = new DataClasses1DataContext();
        List<Table2> lst = new List<Table2>();
        dc.DeleteTable2(2);
        dc.SubmitChanges();
        lst = (from x in dc.Table2s select x).ToList();
        dataGrid观点1.DataSource = lst;
    }

友情链接