Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding New Entity in Oracle database
Message
From
29/01/2009 02:11:30
 
 
To
28/01/2009 09:10:56
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Database:
Oracle
Application:
Desktop
Miscellaneous
Thread ID:
01377558
Message ID:
01378002
Views:
25
--Is this a Windows forms application?
Yes, it is windows form application

--Are you making these calls inside a form?
I am making call from the windows form as well as unit testing it in a sepearte NUnit project.

--Is the ClientMasterEntity the only Entity object you created for the ClientMaster business object?
Yes, clientMasterEntity is the only entity created for this ClientMaster business object

--If these are all true, what is triggering the creation of a new entity? Is this from a button?
In the windows form application, yes it is a form button
In the NUnit project, i have just defined this as a Test method

Thanks for your solution,and thanks for your help i really appreciate it, it works once i make change the base class for the ClientMaster
DataAccess as per Kevin McNeish suggestion

--Vidya,

--I don’t know if this is an issue with the case of your stored procedure names, but try this:

--1. Create an ADataAccessOracle class (subclassed from mmDataAccessOracle) in your project.
--

--2. Add the following method override to the class:
-- public override DataTable GetStoredProcedureParameters(string schema, string storedProcedure)
--
-- {

-- //UCase the stored procedure name
--
-- storedProcedure = storedProcedure.ToUpper();

-- return base.GetStoredProcedureParameters(schema, storedProcedure);

-- }

--3. If you are using custom data access classes, change your custom data access class so it is a subclass of this new
-- ADataAccessOracle class. If you are not using custom data access classes, change your project’s Factory class CreateDataAccessOracle() --- method so it returns and instance of ADataAccessOracle. For example:

-- return new ADataAccessOracle();

-- Best Regards,


-- Kevin McNeish

-- Microsoft .NET MVP

-- INETA Speaker

-- President, Oak Leaf Enterprises, Inc.

-- Web: http://www.oakleafsd.com

-- Blog: http://www.msmvps.com/KevinMcNeish



-- this.NewRow();
-- or if you are calling this on a business object other than the primary business object you can call the overload
-- this.NewRow(ClientMaster);
-- After all the edits, etc are complete you can just call the forms save

-- mmSaveDataResult result = this.Save();
-- or for business objects other than the primary you can call the overload
-- mmSaveDataResult result = this.Save(ClientMaster);


-- Can you fill me in a bit on what you are trying to do, maybe we can simplify the process a bit.
-- By the way, are you using an evaluation version of MM?


I am trying to create a new record for Client_Master and save the data back to the database.

No i am not using an Evaluation version of MM, we actually purchase 2 copies last year


Thanks & Kind Regards
Vidya
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform