Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using (Entities context = new Entities())
- {
- context.MyStoreadProcedure(Parameters);
- }
- sqlStr = "CALL updateGame(?,?,?,?,?,?,?)";
- commandObj = new OdbcCommand(sqlStr, mainConnection);
- commandObj.Parameters.Add("@id,", OdbcType.Int).Value = inGame.id;
- commandObj.Parameters.Add("@name", OdbcType.VarChar, 255).Value = inGame.name;
- commandObj.Parameters.Add("@description", OdbcType.Text).Value = ""; //inGame.description;
- commandObj.Parameters.Add("@yearPublished", OdbcType.DateTime).Value = inGame.yearPublished;
- commandObj.Parameters.Add("@minPlayers", OdbcType.Int).Value = inGame.minPlayers;
- commandObj.Parameters.Add("@maxPlayers", OdbcType.Int).Value = inGame.maxPlayers;
- commandObj.Parameters.Add("@playingTime", OdbcType.VarChar, 127).Value = inGame.playingTime;
- return Convert.ToInt32(executeScaler(commandObj));
- CREATE DEFINER=`106228`@`%` PROCEDURE `updateGame`(
- inId INT,
- inName VARCHAR(255),
- inDescription TEXT,
- inYearPublished DATETIME,
- inMinPlayers INT,
- inMaxPlayers INT,
- inPlayingTime VARCHAR(127)
- )
- SqlParameter param1 = new SqlParameter("@firstName", "Frank");
- SqlParameter param2 = new SqlParameter("@lastName", "Borland");
- context.Database.ExecuteSqlCommand("sp_MyStoredProc @firstName, @lastName",
- param1, param2);
- var oficio= new SqlParameter
- {
- ParameterName = "pOficio",
- Value = "0001"
- };
- using (var dc = new PCMContext())
- {
- return dc.Database
- .SqlQuery<ProyectoReporte>("exec SP_GET_REPORTE @pOficio",
- oficio)
- .ToList();
- }
- using (Entities context = new Entities())
- {
- context.MyStoreadProcedure(Parameters);
- }
- using (testentities te = new testentities())
- {
- //-------------------------------------------------------------
- // Simple stored proc
- //-------------------------------------------------------------
- var parms1 = new testone() { inparm = "abcd" };
- var results1 = te.CallStoredProc<testone>(te.testoneproc, parms1);
- var r1 = results1.ToList<TestOneResultSet>();
- }
- [TestClass]
- public class TenantDataBasedTests : BaseIntegrationTest
- {
- [TestMethod]
- public void GetTenantForName_ReturnsOneRecord()
- {
- // ARRANGE
- const int expectedCount = 1;
- const string expectedName = "Me";
- // Build the paraemeters object
- var parameters = new GetTenantForTenantNameParameters
- {
- TenantName = expectedName
- };
- // get an instance of the stored procedure passing the parameters
- var procedure = new GetTenantForTenantNameProcedure(parameters);
- // Initialise the procedure name and schema from procedure attributes
- procedure.InitializeFromAttributes();
- // Add some tenants to context so we have something for the procedure to return!
- AddTenentsToContext(Context);
- // ACT
- // Get the results by calling the stored procedure from the context extention method
- var results = Context.ExecuteStoredProcedure(procedure);
- // ASSERT
- Assert.AreEqual(expectedCount, results.Count);
- }
- }
- internal class GetTenantForTenantNameParameters
- {
- [Name("TenantName")]
- [Size(100)]
- [ParameterDbType(SqlDbType.VarChar)]
- public string TenantName { get; set; }
- }
- [Schema("app")]
- [Name("Tenant_GetForTenantName")]
- internal class GetTenantForTenantNameProcedure
- : StoredProcedureBase<TenantResultRow, GetTenantForTenantNameParameters>
- {
- public GetTenantForTenantNameProcedure(
- GetTenantForTenantNameParameters parameters)
- : base(parameters)
- {
- }
- }
- public List<CumulativeInstrumentsDataRow> GetCumulativeInstrumentLogs(RunLogFilter filter)
- {
- EFDbContext db = new EFDbContext();
- if (filter.SystemFullName == string.Empty)
- {
- filter.SystemFullName = null;
- }
- if (filter.Reconciled == null)
- {
- filter.Reconciled = 1;
- }
- string sql = GetRunLogFilterSQLString("[dbo].[rm_sp_GetCumulativeInstrumentLogs]", filter);
- return db.Database.SqlQuery<CumulativeInstrumentsDataRow>(sql).ToList();
- }
- public string GetRunLogFilterSQLString(string procedureName, RunLogFilter filter)
- {
- return string.Format("EXEC {0} {1},{2}, {3}, {4}", procedureName, filter.SystemFullName == null ? "null" : "'" + filter.SystemFullName + "'", filter.MinimumDate == null ? "null" : "'" + filter.MinimumDate.Value + "'", filter.MaximumDate == null ? "null" : "'" + filter.MaximumDate.Value + "'", +filter.Reconciled == null ? "null" : "'" + filter.Reconciled + "'");
- }
- using (var ctx = new SchoolDBEntities())
- {
- Student stud = new Student();
- stud.StudentName = "New sp student";
- stud.StandardId = 262;
- ctx.Students.Add(stud);
- ctx.SaveChanges();
- }
Add Comment
Please, Sign In to add comment