How Parent and Child record can be inserted in Single Statement : Use of External id field

Date dt = Date.today().addDays(7);

2	Opportunity newOpportunity = new Opportunity(Name = 'shivasoft', StageName ='Prospecting', CloseDate = dt);

3

4

/*

5	Create the parent reference. Used only for foreign key reference  and doesn't contain any other fields. If we provide any other value it will give following error

6

7	System.DmlException: Insert failed. First exception on row 1; first error: INVALID_FIELD, More than 1 field provided in an external foreign key reference in entity: Account: []

8

*/

9

10	Account accountReference = new Account(MyExtID__c = 'SHIVA1234567');

11	newOpportunity.Account = accountReference;

12

13	//  Create the Account object to insert.  Same as above but has Name field.  Used for the insert.

14	Account parentAccount = new Account(Name = 'Shiva', MyExtID__c = 'SHIVA1234567');

15

16	Database.SaveResult[]

17	results = Database.insert(new SObject[] {  parentAccount, newOpportunity });

Note : parent object should be included before the child object in list otherwise you will get following error : 

 INVALID_FIELD, Foreign key external ID: SHIVA1234567 not found for field  MyExtID__c  in entity Account: []

Salesforce Tips

If we remove "Modify All Data" permission from a user then there is some other permissions are also removed with this.
Ex - after removing modify all data user can not edit apex classes. Even after applying modify all data still user can not edit apex classes.

Reason : Apex Author permission is also removed from the profile when we remove Modify all data.
Solution : check Apex author checkbox on profile level then you are able to edit apex classes again.

Error during deployment

•  Error :  "Entity is not org-accessible" error while deployment or saving the classes.

          Cause of the error - You have written a code that share a record and sharing model is not set to  private.

          Solution :  set sharing model to private for the object you are applying sharing rule in your code.
Security control -.> Sharing Settings -> select object -> Set OWD private

•  Error : APEX deploy fails "Package Version number does not exist" while saving the classes and pages.

          Cause : Classes are dependent on installed package. Your org has lower package version installed and the classes you want to deploy are in higher package version.

You can check your installed package version in your org:
App Setup -> Installed Packages_>click on your package ->see the Version Number

Package version of the class can be checked by version setting or by metadata file in eclipse.

Solution : 1. Upgrade the package of your org.
                 2. Try setting your project to work offline.Edit the metadata file and remove the dependencies on the manage package, then deploy straight to the target org.

Go to your project in eclips -> force.com -> work offline -> remove the dependancy of your classes and pages on package then deploy to server.