public void SaveDapper(UserSql userSql) { new Microsoft.Data.SqlClient.SqlConnection(_connAzureSql) .Insert(new UserSql { Name = userSql.Name }); }
public async Task <IActionResult> Run( [HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = "cadastro")] HttpRequest req, ILogger log) { log.LogInformation("C# HTTP trigger function processed a request."); string name = req.Query["name"]; if (req.Method == HttpMethods.Post) { string requestBody = await new StreamReader(req.Body).ReadToEndAsync(); UserSql data = System.Text.Json.JsonSerializer.Deserialize <UserSql>(requestBody, new System.Text.Json.JsonSerializerOptions { PropertyNameCaseInsensitive = true }); _azureSqlRepository.SaveDapper(data); return(new OkObjectResult("Saved")); } else if (req.Method == HttpMethods.Get) { var itens = _azureSqlRepository.GetAll(); return(new OkObjectResult(itens)); } else { return(new NotFoundResult()); } }
public void SaveADO(UserSql userSql) { using (var command = _sqlConnection.CreateCommand()) { command.Connection = new SqlConnection(_connAzureSql); command.CommandType = System.Data.CommandType.Text; command.CommandText = "INSERT INTO UserSqls (Name) values ('@Name')"; var parameterName = command.CreateParameter(); parameterName.ParameterName = nameof(userSql.Name); parameterName.Value = userSql.Name; command.Parameters.Add(parameterName); if (command.Connection.State != System.Data.ConnectionState.Open) { command.Connection.Open(); } command.ExecuteNonQuery(); command.Connection.Close(); } }