LightSpeed SQL and the use of stored procedures

While using the query provided by Lightspeed can solve most of the problems, if the business logic is too complex, it is sometimes necessary to execute SQL statements or stored procedures

The way to use SQL is by using Findbysql.

The Findbysql parameter has only one Command.

And the way to create a command is not that simple.

var cmd = UnitOfWork.Context.DataProviderObjectFactory.CreateCommand ();

Command needs to be given text, and there may be parameters

" exec Dbo.my_stored_proc " ;
Or

Cmd.commandtext = "SELECT * from Table";

varmetadata =New[] {NewSqlMetaData ("value", SqlDbType.NVarChar,Ten) };//The members of your SQL Server table typevarData1 =NewSqlDataRecord (metadata);//In reality you ' d Create a helper method for thisData1. Setvalues ("1");varData2 =NewSqlDataRecord (metadata);d ata2. Setvalues ("2");vardata =New[] {data1, data2};cmd. Parameters.Add (NewSqlParameter ("@stringArrayInput", data) {SqlDbType = sqldbtype.structured});

LightSpeed use of SQL and stored procedures