Dictionary collection support in ODP.NET
-
Hi there, I use Oracle 11gR2 database. I am developing in Visual Studio 2013 with C# and using ODP.NET. Question 1 Does ODP.NET support Dictionary collection? I couldn't seem to find the necessary information so i was wondering if someone could explain if this is possible please? Question 2 Secondly I have the following collection:
Dictionary> myDict = new Dictionary>();
My intention is to send this collection to my stored procedure and perform a Bulk insert of this data. If it is possible how can I go about doing this? Can someone provide me with example in PL/SQL and C# please? Kind Regards,
-
Hi there, I use Oracle 11gR2 database. I am developing in Visual Studio 2013 with C# and using ODP.NET. Question 1 Does ODP.NET support Dictionary collection? I couldn't seem to find the necessary information so i was wondering if someone could explain if this is possible please? Question 2 Secondly I have the following collection:
Dictionary> myDict = new Dictionary>();
My intention is to send this collection to my stored procedure and perform a Bulk insert of this data. If it is possible how can I go about doing this? Can someone provide me with example in PL/SQL and C# please? Kind Regards,
No database engine out there knows what a .NET Dictionary is. Since your using a stored procedure on the database side, you might be a bit disappointed. Read these[^].
A guide to posting questions on CodeProject
Click this: Asking questions is a skill. Seriously, do it.
Dave Kreskowiak -
No database engine out there knows what a .NET Dictionary is. Since your using a stored procedure on the database side, you might be a bit disappointed. Read these[^].
A guide to posting questions on CodeProject
Click this: Asking questions is a skill. Seriously, do it.
Dave KreskowiakThanks for your input. I will check those links out. Ultimately what I am trying to achieve is to improve the performance of the application I am working on. Currently I do a database call for each entity. This works but from a performance aspect it isn't good hence why I decided to ask the dev community.