Want to send large data(ex, List) to SP, using NHibernate in .Net

Question

How can I send "List" to SP in .NET? I used loop util now, but it has low performance beacuse of overfull I/O Connection. So, I think that Sending "List" to DB Server is solution.

(Under code is Sample)

ISession session = ....;
Foreach(ProductDto PD in insertList)
{
  IQuery query = session.CreateSQLQuery("exec Log @A=:a, @B=:b");
  query.SetDateTime("A", ProductDto.a);
  query.SetString("B", ProductDto.b);
  query.ExecuteUpdate();
}

You can pass a table into the SP Take a look at this, see if it helps: http://www.mssqltips.com/sqlservertip/2112/table-value-parameters-in-sql-server-2008-and-net-c/ — User2012384, Mar 19 '15 at 01:09

score 0 · Answer 1 · edited May 23 '17 at 12:06

0

Calling of stored procedure and passing it a list as input is answered here: Passing List<> to SQL Stored Procedure

edited May 23 '17 at 12:06

Community

1
1

answered Mar 20 '15 at 09:25

webcodervk

145
8

Want to send large data(ex, List) to SP, using NHibernate in .Net

1 Answers1