Learn simple. data advanced, learn simple. data

Learn simple. data advanced, learn simple. data

1. Call the Stored Procedure

1. Without Parameters

CREATE PROCEDURE ProcedureWithoutParamsAS SELECT * FROM ORDER;

Call db. ProcedureWithoutParams ();

2. With Parameters

CREATE PROCEDURE ProcedureWithoutParams@ORDERCODE VARCHAR(MAX)AS SELECT * FROM ORDER WHERE ORDERCODE=@ORDERCODE;

Call db. ProcedureWithoutParams (1 );

Or db. ProcedureWithoutParams (ORDERCODE: 1 );

Ii. Transactions

Using (var transaction = db. BeginTransaction () {transaction. Users. Insert (Name: "Zhang San", Age: 20); transaction. Commit ();}

3. Paging

1. Retrieve multiple data records without skipping data

IEnumerable<dynamic> q = db.Order.All().Take(10).ToList<dynamic>();

2. Skipping multiple records and returning multiple data records

IEnumerable<dynamic> q = db.Order.All().Skip(10).Take(10).ToList<dynamic>();

 

Iv. Experience in Simple. Data. Oracle

1. Use Sequence

Db. Customer. Insert (CustomerId: Sequence. Next ("Customers_SEQ "));

Add CustomerId as the foreign key of Order. When adding a new Order, you must obtain the generated Sequence and assign it to Order.

using (var tx = db.BeginTransaction()){db.Customer.Insert(CustomerId:Sequence.Next("Customers_SEQ"));db.Order.Insert(CustomerId:Sequence.Current("Customers_SEQ"));tx.Commit();}

 

2. Stored Procedure Call

Currently, cursor return is not supported.

create or replace PROCEDURE ORDERCOUNTBYFACTORYNAME(V_FACTORYNAME  IN VARCHAR,V_COUNT OUT NUMBER) 
ISbeginselect COUNT(*) INTO V_COUNT FROM ORDER OINNER JOIN ORDERDETAIL OD on O.PKID= OD.ORDERIDWHERE O.FACTORYNAME = V_FACTORYNAME ;end ORDERCOUNTBYFACTORYNAME;

The calling method consists of the header name + _ + stored procedure name.

var result = db.PKG__ORDERCOUNTBYFACTORYNAME("SO20140917");var count = result.OutputValues["V_COUNT "];

 

If you click "advanced learning", you can replace the learning skills? This happened to my friend, right?

Dear gamer, our customer service on the Seventh Avenue is very happy to answer your questions. If the current skill is full, the skill will be replaced even if you click Advanced learning. If the skill is insufficient, if you select Advanced learning, there will be no replacement skills. Thank you for your support for the game and wish you a pleasant game.

How to Learn advanced spells

Namwon Huang's Fire spells,
Wang pengxu himself carries a wind spell,
Xingxuan (EARTH), Wen Hui (water), Lei yuange (LEI)
Let's take a look at the following description and consider the final ending. Only one of the endings of raymongo will join the battle, so it is a waste of learning dual-series spells.
In addition, if you want to make a final conclusion, you need to make Namwon Huang use more than five arms, so it is not necessary to let him learn the third series of spells.

In my opinion, if we want to practice attacks, we should give Yan Su or Lei Jue to Xing Xuan,
If Yan Su gives Xing Xuan, Lei Jue gives Peng Xu,
If Lei Jue gives Xing Xuan, Yan Su gives Wen Hui.

Should there be a water system spell? It should be called a mirror.
You can give the goggles to the canvas.

Lz can refer to the following combination to find out the appropriate gameplay method.

General fairy arts can be upgraded only when used for a maximum of four levels.

Advanced Fairy tales can be learned only when they reach a certain level (level 45-50.

Water + wind: wind exposure (restoring 100% of our single Users)

Water + wind: wind, snow, and ice (attack technology)

Water + fire: Curse (restoring all other undesirable states except poisoning)

Fire + wind: Fire detection Day (attack technology)

Fire + Earth: Xingshen earthquake (attack technology)

Fire + mine: Flame mine (attack technology)

Ice + Ray: redeem the soul light (we have a single resurrection, while restoring a lot of precision)

Thunder + Earth: the magic of the Sky (adding our single weapon, defense, speed, and Operation)

Dual-series spells:

Feng Lu Yin-warm fog 3 + rain hate cloud sorrow 2 35 level

Spirit and blood curse-three muzhen fire 3 + Smoke, water, and soul 4 40 levels

Redemption of the soul light-Battle of the sky 4 + rain hate cloud sorrow 4 42

Wind, snow, ice, and sky-xianyunyunyunfeng 4 + rain and hate cloud sorrow 3 45

Tianxiao-tianyao battle Air 4 + bearing things 4 45 levels

Flame Burning thunder-Meteor fire rain 3 + thunder and air breaking 3 48 levels

Fire detection days-Purgatory fire sea 3 + fairy storm 4 48 level

Xingshen earthquake-Purgatory fire sea 4 + zhenyuan body guard 4 50