Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Sep 26, 2012 06:02 PM by muhammadazeemazam
Sep 26, 2012 03:28 PM|LINK
I have populated a class from different tables.
Now i want that class to be assigned to a table (that has same fields as my class attributes) in SQL Server.
Should i create a store pocedure and pass all class attributes as parameters and then using Insert command.
Looking for Possible Solutions.
Sep 26, 2012 05:44 PM|LINK
yes you are correct, you have to create a store procedure and call it from your code-behind before calling fill store procedure parameter with your class property. Inside store procedure you have to insert data in the tables.
Sep 26, 2012 05:48 PM|LINK
Sounds like you might need something like Entity Framework or an other ORM system.
Sep 26, 2012 06:02 PM|LINK
The problem is what if i have 10000 recors (rows). this means i am calling store procedure 10000 time. performace degraded..
any other solution would be helpful