自动/智能插入“本身"目的 [英] Automatic/Smart insert "itself" object

问题描述

我想通过单一方法将我的 UserCompany 对象插入数据库.比如将元素传递给这个函数，取它并插入右表".

I'd like to insert my UserCompany object into the database trought a single method. Such as passing the element to this function, take it and "insert in the right table".

通常在实体中(例如 LINQ to XML)我会做类似的事情:

Usually in Entity (such as LINQ to XML) I do somethings like:

db.Company.UsersCompany.Add(UserCompany);
db.SubmitChanges();

但这里的问题是我需要在使用 .Add() 之前指定表 UsersCompany 和 Company.我想(因为我想为每种类型的对象/表的插入执行一个函数)摆脱这个.比如有一个:

but the problem here is that I need to specify the table UsersCompany and Company before using the .Add(). I'd like (since I want to do ONE function for the insert for each type of object/table) get rid of this. Such as having a:

UserCompany.InsertMySelf();

或

db.SmartAdd(UserCompany);

它知道如何自动插入表格，在哪里以及如何插入.

and it know how to insert the table, where and how, automatically.

可以这样做吗?有什么策略吗?

Is it possible to do this? Is there any strategies?

推荐答案

你可以用泛型解决这个问题:

You can solve this with generics:

Public Sub AddEntities(Of TEntity)(entities As IEnumerable(Of TEntity))
   For Each ent In entities
       _db.Set(Of TEntity).Add(ent)
   Next
   _db.SaveChanges()
End Sub

很抱歉使用 VB...在 C# 中:

Sorry for using VB... In C#:

public void AddEntities<TEntity>(IEnumerable<TEntity> entities)
   {
     foreach(ent in entities)
     {
         _db.Set<TEntity>.Add(ent);
     }
     _db.SaveChanges();
   }

这篇关于自动/智能插入“本身"目的的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！