InvalidOperationException: 该应用程序或请求尚未配置会话。

huangapple
go评论151阅读模式
英文:

.net 7 Visual Studio Code : InvalidOperationException: Session has not been configured for this application or request

问题

I followed the example of this tutorial (https://www.c-sharpcorner.com/article/simple-login-and-registration-form-in-asp-net-mvc-using-ado-net/) to create a simple registration and login pages for C# MVC .Net Web app.

我按照这个教程的示例（https://www.c-sharpcorner.com/article/simple-login-and-registration-form-in-asp-net-mvc-using-ado-net/）创建了一个简单的C# MVC .Net Web应用程序的注册和登录页面。

I was able to implement the user registration to a local mysql hosted by Xampp.

我成功实现了用户注册到由Xampp托管的本地mysql数据库。

However for the UserLoginController I'm getting the following error:

但是对于UserLoginController，我遇到了以下错误：

InvalidOperationException: Session has not been configured for this application or request.
Microsoft.AspNetCore.Http.DefaultHttpContext.get_Session()
Project.UserLoginController.Index(Enroll e) in UserLoginController.cs
+
HttpContext.Session.SetString("Email", e.Email);
lambda_method28(Closure , object , object[] )

InvalidOperationException: 尚未为此应用程序或请求配置会话。
Microsoft.AspNetCore.Http.DefaultHttpContext.get_Session()
Project.UserLoginController.Index(Enroll e) in UserLoginController.cs
+
HttpContext.Session.SetString("Email", e.Email);
lambda_method28(Closure , object , object[] )

Below are some of my code and configuration:

以下是我的一些代码和配置：

Startup.cs (I had to add manually because "dotnet new mvc -o Project did not add it")

Startup.cs（我不得不手动添加，因为"dotnet new mvc -o Project"没有添加它）

  1. using Microsoft.AspNetCore.Builder;
  2. using Microsoft.AspNetCore.Hosting;
  3. using Microsoft.Extensions.DependencyInjection;
  4. using Microsoft.Extensions.Hosting;
  5. using Microsoft.AspNetCore.Http;
  7. namespace Project
  8. {
  9.     public class Startup
  10.     {
  11.         public void ConfigureServices(IServiceCollection services)
  12.         {
  13.             services.AddDistributedMemoryCache();
  14.             services.AddSession(options =>
  15.             {
  16.                 options.Cookie.HttpOnly = true;
  17.                 options.Cookie.IsEssential = true;
  18.             });
  20.             services.AddSingleton<IHttpContextAccessor, HttpContextAccessor>(); // Add this line
  22.             // Other service configurations
  23.         }
  25.         public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
  26.         {
  27.             // Other middleware configurations
  29.             app.UseSession();
  31.             app.UseRouting();
  33.             // Other endpoint and routing configurations
  34.         }
  35.     }
  36. }

UserLoginController.cs

UserLoginController.cs

  1. using Microsoft.AspNetCore.Mvc;
  2. using System.Data;
  3. using MySql.Data.MySqlClient;
  4. using Project.Models;
  5. using System.Data.SqlClient;
  7. namespace Project.Controllers
  8. {
  9.     public class UserLoginController : Controller
  10.     {
  11.         // GET: /UserLogin/
  12.         public string status;
  14.         public ActionResult Index()
  15.         {
  16.             return View();
  17.         }
  18.         [HttpPost]
  19.         public ActionResult Index(Enroll e)
  20.         {
  21.             string connectionString = "Server=localhost;Port=3306;Database=database;Uid=root;Pwd=root;";
  22.             using (MySqlConnection con = new MySqlConnection(connectionString))
  23.             {
  24.                 string sqlQuery = "SELECT Email, Password FROM Enrollment WHERE Email = @Email AND Password = @Password";
  25.                 con.Open();
  26.                 MySqlCommand cmd = new MySqlCommand(sqlQuery, con);
  27.                 cmd.Parameters.AddWithValue("@Email", e.Email);
  28.                 cmd.Parameters.AddWithValue("@Password", e.Password);
  29.                 MySqlDataReader reader = cmd.ExecuteReader();
  31.                 if (reader.Read())
  32.                 {
  33.                     HttpContext.Session.SetString("Email", e.Email);
  34.                     return RedirectToAction("Welcome");
  35.                 }
  36.                 else
  37.                 {
  38.                     ViewData["Message"] = "User Login Details Failed!!";
  39.                 }
  41.                 con.Close();
  42.             }
  44.             return View();
  45.         }
  47.         [HttpGet]
  48.         public ActionResult Welcome()
  49.         {
  50.             Enroll user = new Enroll();
  51.             DataSet ds = new DataSet();
  53.             string connectionString = "Server=localhost;Port=3306;Database=database;Uid=root;Pwd=root;";
  54.             using (MySqlConnection con = new MySqlConnection(connectionString))
  55.             {
  56.                 using (MySqlCommand cmd = new MySqlCommand("sp_GetEnrollmentDetails", con))
  57.                 {
  58.                     cmd.CommandType = CommandType.StoredProcedure;
  59.                     cmd.Parameters.AddWithValue("@Email", HttpContext.Session.GetString("Email"));
  60.                     con.Open();
  61.                     MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
  62.                     adapter.Fill(ds);
  63.                     List<Enroll> userlist = new List<Enroll>();
  64.                     foreach (DataRow row in ds.Tables[0].Rows)
  65.                     {
  66.                         Enroll uobj = new Enroll();
  67.                         uobj.ID = Convert.ToInt32(row["ID"].ToString());
  68.                         uobj.FirstName = row["FirstName"].ToString();
  69.                         uobj.LastName = row["LastName"].ToString();
  70.                         uobj.Password = row["Password"].ToString();
  71.                         uobj.Email = row["Email"].ToString();
  72.                         uobj.PhoneNumber = row["Phone"].ToString();
  73.                         uobj.SecurityAnswer = row["SecurityAnswer"].ToString();
  74.                         uobj.Gender = row["Gender"].ToString();
  76.                         userlist.Add(uobj);
  77.                     }
  78.                     user.Enrollsinfo = userlist;
  79.                 }
  80.                 con.Close();
  81.             }
  83.             ViewBag.Email = HttpContext.Session.GetString("Email");
  85.             return View(user);
  86.         }
  88.         public ActionResult Logout()
  89.         {
  90.             HttpContext.Session.Clear();
  91.             return RedirectToAction("Index", "UserLogin");
  92.         }
  93.     }
  94. }

Index.cshtml

Index.cshtml

  1. @model Project.Enroll
  3. @{
  4.     ViewBag.Title = "Index";
  5. }
  7. <!DOCTYPE html>
  8. <html>
  9. <head>
  10.     <meta name="viewport" content="width=device-width" />
  11.     <title>ENROLLMENT</title>
  12.     <link href="http://maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css" />
  13.     <script type="text/javascript" src="http://maxcdn.bootstrapcdn.com/bootstrap/4.1.1/js/bootstrap.min.js"></script>
  14.     <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  15.     <link href="../../Content/StyleSheet.css" rel="stylesheet" type="text/css" />
  16.     <script type="text/javascript">
  17.         $(document).ready(function () {
  18.             $.ajax({
  20.                 type: 'POST',
  21.                 URL: '/UserLogin/UserLogin',
  22.                 data: data,
  23.                 dataType: 'JSON',
  24.                 success: function (data) {
  25.                     datadata = data.status
  26.                     if (status == "1") {
  27.                         window.location.href = '@Url.Action("Index","UserLogin")';
  28.                     }
  29.                 }
  30.             });
  31.         });
  32.     </script>
  33. </head>
  35. <body>
  36. <!------ Include the above in your HEAD tag ---------->
  37. @using (Html.BeginForm("Index", "UserLogin", FormMethod.Post))
  38. {
  39.     @Html.AntiForgeryToken()
  40.     <div class="container register">
  41.         <div class="row">
  42.             <div class="col-md-3 register-left">
  43.                 <img src="https://image.ibb.co/n7oTvU/logo_white.png" alt="" />
  44.                 <h3>Welcome</h3>
  45.                 <p>This Example is for learning MVC Basic Login and Registration Using ADO.NET.</p>
  46.             </div>
  47.             <div class="col-md-9 register-right">
  48.                 <ul class="nav nav-tabs nav-justified" id="myTab" role="tablist">
  49.                     <li
  51. <details>
  52. <summary>英文:</summary>
  54. I followed the example of this tutorial (https://www.c-sharpcorner.com/article/simple-login-and-registration-form-in-asp-net-mvc-using-ado-net/)  to create a simple registration and login pages for C# MVC .Net Web app. 
  56. I was able to implement the user registration to a local mysql hosted by Xampp
  58. However for the UserLoginController I&#39;m getting the following error:
  60.     InvalidOperationException: Session has not been configured for this application or request.
  61.     Microsoft.AspNetCore.Http.DefaultHttpContext.get_Session()
  62.     Project.UserLoginController.Index(Enroll e) in UserLoginController.cs
  63.     +
  64.                         HttpContext.Session.SetString(&quot;Email&quot;, e.Email);
  65.     lambda_method28(Closure , object , object[] )
  67. Below are some of my code and configuration:
  69. Startup.cs (I had to add manually because &quot;dotnet new mvc -o Project did not add it&quot;)
  71.     using Microsoft.AspNetCore.Builder;
  72.     using Microsoft.AspNetCore.Hosting;
  73.     using Microsoft.Extensions.DependencyInjection;
  74.     using Microsoft.Extensions.Hosting;
  75.     using Microsoft.AspNetCore.Http;
  76.     
  77.     
  78.     namespace Project
  79.     {
  80.         public class Startup
  81.         {
  82.             public void ConfigureServices(IServiceCollection services)
  83.             {
  84.                 services.AddDistributedMemoryCache();
  85.                 services.AddSession(options =&gt;
  86.                 {
  87.                     options.Cookie.HttpOnly = true;
  88.                     options.Cookie.IsEssential = true;
  89.                 });
  90.     
  91.                 services.AddSingleton&lt;IHttpContextAccessor, HttpContextAccessor&gt;(); // Add this line
  92.     
  93.                 // Other service configurations
  94.             }
  95.     
  96.     
  97.             public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
  98.             {
  99.                 // Other middleware configurations
  100.                 
  101.                 app.UseSession();
  102.                 
  103.                 app.UseRouting();
  104.                 
  105.                 // Other endpoint and routing configurations
  106.             }
  107.     
  108.         }
  109.     }
  111. UserLoginController.cs
  113.     using Microsoft.AspNetCore.Mvc;
  114.     using System.Data;
  115.     using MySql.Data.MySqlClient;
  116.     using Project.Models;
  117.     using System.Data.SqlClient;
  118.     
  119.     namespace Project.Controllers
  120.     {  
  121.         public class UserLoginController : Controller  
  122.         {   
  123.             // GET: /UserLogin/  
  124.             public string status;  
  125.               
  126.             public ActionResult Index()  
  127.             {  
  128.                 return View();  
  129.             }  
  130.             [HttpPost]  
  131.             public ActionResult Index(Enroll e)
  132.             {
  133.                 string connectionString = &quot;Server=localhost;Port=3306;Database=database;Uid=root;Pwd=root;&quot;;
  134.                 using (MySqlConnection con = new MySqlConnection(connectionString))
  135.                 {
  136.                     string sqlQuery = &quot;SELECT Email, Password FROM Enrollment WHERE Email = @Email AND Password = @Password&quot;;
  137.                     con.Open();
  138.                     MySqlCommand cmd = new MySqlCommand(sqlQuery, con);
  139.                     cmd.Parameters.AddWithValue(&quot;@Email&quot;, e.Email);
  140.                     cmd.Parameters.AddWithValue(&quot;@Password&quot;, e.Password);
  141.                     MySqlDataReader reader = cmd.ExecuteReader();
  142.                     
  143.                     if (reader.Read())
  144.                     {
  145.                         HttpContext.Session.SetString(&quot;Email&quot;, e.Email);
  146.                         return RedirectToAction(&quot;Welcome&quot;);
  147.                     }
  148.                     else
  149.                     {
  150.                         ViewData[&quot;Message&quot;] = &quot;User Login Details Failed!!&quot;;
  151.                     }
  152.     
  153.                     con.Close();
  154.                 }
  155.     
  156.                 return View();
  157.             }
  158.     
  159.             [HttpGet]
  160.             public ActionResult Welcome()
  161.             {
  162.                 Enroll user = new Enroll();
  163.                 DataSet ds = new DataSet();
  164.     
  165.                 string connectionString = &quot;Server=localhost;Port=3306;Database=database;Uid=root;Pwd=root;&quot;;
  166.                 using (MySqlConnection con = new MySqlConnection(connectionString))
  167.                 {
  168.                     using (MySqlCommand cmd = new MySqlCommand(&quot;sp_GetEnrollmentDetails&quot;, con))
  169.                     {
  170.                         cmd.CommandType = CommandType.StoredProcedure;
  171.                         cmd.Parameters.AddWithValue(&quot;@Email&quot;, HttpContext.Session.GetString(&quot;Email&quot;));
  172.                         con.Open();
  173.                         MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
  174.                         adapter.Fill(ds);
  175.                         List&lt;Enroll&gt; userlist = new List&lt;Enroll&gt;();
  176.                         foreach (DataRow row in ds.Tables[0].Rows)
  177.                         {
  178.                             Enroll uobj = new Enroll();
  179.                             uobj.ID = Convert.ToInt32(row[&quot;ID&quot;].ToString());
  180.                             uobj.FirstName = row[&quot;FirstName&quot;].ToString();
  181.                             uobj.LastName = row[&quot;LastName&quot;].ToString();
  182.                             uobj.Password = row[&quot;Password&quot;].ToString();
  183.                             uobj.Email = row[&quot;Email&quot;].ToString();
  184.                             uobj.PhoneNumber = row[&quot;Phone&quot;].ToString();
  185.                             uobj.SecurityAnswer = row[&quot;SecurityAnswer&quot;].ToString();
  186.                             uobj.Gender = row[&quot;Gender&quot;].ToString();
  187.     
  188.                             userlist.Add(uobj);
  189.                         }
  190.                         user.Enrollsinfo = userlist;
  191.                     }
  192.                     con.Close();
  193.                 }
  194.     
  195.                 ViewBag.Email = HttpContext.Session.GetString(&quot;Email&quot;);
  196.     
  197.                 return View(user);
  198.             }
  199.     
  200.     
  201.             public ActionResult Logout()
  202.             {
  203.                 HttpContext.Session.Clear();
  204.                 return RedirectToAction(&quot;Index&quot;, &quot;UserLogin&quot;);
  205.             }
  206.         }
  207.     } 
  209. Index.cshtml
  211.     @model Project.Enroll    
  212.         
  213.     @{    
  214.         ViewBag.Title = &quot;Index&quot;;    
  215.     }    
  216.     &lt;!DOCTYPE html&gt;    
  217.     &lt;html&gt;    
  218.     &lt;head&gt;    
  219.     &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width&quot; /&gt;    
  220.     &lt;title&gt;ENROLLMENT&lt;/title&gt;    
  221.     &lt;link href=&quot;http://maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css&quot; rel=&quot;stylesheet&quot; id=&quot;bootstrap-css&quot;/&gt;    
  222.     &lt;script type=&quot;text/javascript&quot; src=&quot;http://maxcdn.bootstrapcdn.com/bootstrap/4.1.1/js/bootstrap.min.js&quot;&gt;&lt;/script&gt;    
  223.     &lt;script type=&quot;text/javascript&quot; src=&quot;http://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js&quot;&gt;&lt;/script&gt;    
  224.     &lt;link href=&quot;../../Content/StyleSheet.css&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot; /&gt;    
  225.     &lt;script type=&quot;text/javascript&quot;&gt;    
  226.         
  227.         $(document).ready(function () {    
  228.             $.ajax({    
  229.         
  230.                 type: &#39;POST&#39;,    
  231.                 URL: &#39;/UserLogin/UserLogin&#39;,    
  232.                 data: data,    
  233.                 dataType: &#39;JSON&#39;,    
  234.                 success: function (data) {    
  235.                     datadata = data.status    
  236.                     if (status == &quot;1&quot;) {    
  237.                         window.location.href = &#39;@Url.Action(&quot;Index&quot;,&quot;UserLogin&quot;)&#39;;    
  238.                     }    
  239.                 }    
  240.             });    
  241.         });    
  242.     &lt;/script&gt;    
  243.     &lt;/head&gt;    
  244.         
  245.     &lt;body&gt;    
  246.     &lt;!------ Include the above in your HEAD tag ----------&gt;    
  247.     @using (Html.BeginForm(&quot;Index&quot;, &quot;UserLogin&quot;, FormMethod.Post))    
  248.     {    
  249.     @Html.AntiForgeryToken()      
  250.     &lt;div class=&quot;container register&quot;&gt;    
  251.                     &lt;div class=&quot;row&quot;&gt;    
  252.                         &lt;div class=&quot;col-md-3 register-left&quot;&gt;    
  253.                             &lt;img src=&quot;https://image.ibb.co/n7oTvU/logo_white.png&quot; alt=&quot;&quot;/&gt;    
  254.                             &lt;h3&gt;Welcome&lt;/h3&gt;    
  255.                             &lt;p&gt;This Example is for learning MVC Basic Login and Registration Using ADO.NET.&lt;/p&gt;    
  256.                         &lt;/div&gt;    
  257.                         &lt;div class=&quot;col-md-9 register-right&quot;&gt;    
  258.                             &lt;ul class=&quot;nav nav-tabs nav-justified&quot; id=&quot;myTab&quot; role=&quot;tablist&quot;&gt;    
  259.                                 &lt;li class=&quot;nav-item&quot;&gt;    
  260.                                     &lt;a class=&quot;nav-link active&quot; id=&quot;home-tab&quot; data-toggle=&quot;tab&quot; href=&quot;../Enrollment/Index&quot; role=&quot;tab&quot; aria-controls=&quot;home&quot; aria-selected=&quot;true&quot;&gt;Register&lt;/a&gt;    
  261.                                 &lt;/li&gt;    
  262.                                 &lt;li class=&quot;nav-item&quot;&gt;    
  263.                                     &lt;a class=&quot;nav-link&quot; id=&quot;profile-tab&quot; data-toggle=&quot;tab&quot; href=&quot;../UserLogin/Index&quot; role=&quot;tab&quot; aria-controls=&quot;profile&quot; aria-selected=&quot;false&quot;&gt;Login&lt;/a&gt;    
  264.                                 &lt;/li&gt;    
  265.                             &lt;/ul&gt;    
  266.                             &lt;div class=&quot;tab-content&quot; id=&quot;myTabContent&quot;&gt;    
  267.                                 &lt;div class=&quot;tab-pane fade show active&quot; id=&quot;home&quot; role=&quot;tabpanel&quot; aria-labelledby=&quot;home-tab&quot;&gt;    
  268.                                     &lt;h3 class=&quot;register-heading&quot;&gt;Login as a Employee&lt;/h3&gt;    
  269.                                     &lt;div class=&quot;row register-form&quot;&gt;    
  270.                                         &lt;div class=&quot;col-md-6&quot;&gt;    
  271.                                            &lt;div class=&quot;form-group&quot;&gt;    
  272.                                                 @Html.TextBoxFor(e =&gt; e.Email, new { @class = &quot;form-control&quot;, placeholder = &quot;Your Email *&quot; })    
  273.                                                 @Html.ValidationMessageFor(e =&gt; e.Email)    
  274.                                             &lt;/div&gt;    
  275.                                             &lt;div class=&quot;form-group&quot;&gt;    
  276.                                                @Html.PasswordFor(e =&gt; e.Password, new { id = &quot;password&quot;, @class = &quot;form-control&quot;, placeholder = &quot;Password *&quot; })    
  277.                                                  &lt;span id=&quot;result&quot;&gt;&lt;/span&gt;    
  278.                                                  @Html.ValidationMessageFor(e =&gt; e.Password)    
  279.                                             &lt;/div&gt;    
  280.                                         &lt;div class=&quot;col-md-6&quot;&gt;    
  281.                                              &lt;input type=&quot;submit&quot; class=&quot;btnLogin&quot;  value=&quot;Login&quot;/&gt;    
  282.                                         &lt;/div&gt;    
  283.                                                 
  284.                                         &lt;/div&gt;    
  285.                                             
  286.                                     &lt;/div&gt;    
  287.                                 &lt;/div&gt;    
  288.                              &lt;/div&gt;    
  289.                         &lt;/div&gt;    
  290.                     &lt;/div&gt;    
  291.                        
  292.                    &lt;script type=&quot;text/javascript&quot;&gt;    
  293.                    $(function () {    
  294.                          var msg = &#39;@ViewData[&quot;result&quot;]&#39;;    
  295.                          if (msg == &#39;1&#39;)    
  296.                          {    
  297.                              alert(&quot;User Details Inserted Successfully&quot;);    
  298.                              window.location.href = &quot;@Url.Action(&quot;Index&quot;, &quot;UserLogin&quot;)&quot;;    
  299.                           }    
  300.                       });    
  301.                    &lt;/script&gt;    
  302.                    }    
  303.                 &lt;/div&gt;    
  304.              }    
  305.        &lt;/body&gt;    
  306.     &lt;/html&gt;    
  308. </details>
  311. # 答案1
  312. **得分**: 1
  314. 在.Net 6之前，我们在`Startup.cs`文件中配置服务和中间件，但在.Net 6之后，Asp.Net-Core移除了`Startup.cs`文件，而是使用`Program.cs`文件来配置服务和中间件。
  316. 因此，您不需要手动添加`Startup.cs`文件，可以像这样在`Program.cs`中配置会话：
  318. ```csharp
  319. var builder = WebApplication.CreateBuilder(args);
  321. // 向容器添加其他服务
  323. builder.Services.AddSession(options =>
  324. {
  325.     options.Cookie.HttpOnly = true;
  326.     options.Cookie.IsEssential = true;
  327. });
  329. var app = builder.Build();
  331. // 配置HTTP请求管道
  333. // 添加其他中间件
  335. app.UseSession();
  337. // 添加其他中间件
  339. app.Run();
英文:

Pior to .Net 6, We configure service and middleware in Startup.cs file, But after .Net 6, Asp.Net-Core remove Startup.cs file and use Program.cs file to configure service and middleware.

So you not need to add Startup.cs file manually, Configure session in Program.cs like this:

  1. var builder = WebApplication.CreateBuilder(args);
  2. // Add services to the container.
  3. //other service
  4. builder.Services.AddSession(options =&gt;
  5. {
  6. options.Cookie.HttpOnly = true;
  7. options.Cookie.IsEssential = true;
  8. });
  9. var app = builder.Build();
  10. // Configure the HTTP request pipeline.
  11. //other middleWare
  12. app.UseSession();
  13. //other middleWare
  14. app.Run();

答案2

得分: 0

在 .NET Core 中，我们可以使用以下方式来设置和获取会话值。

要设置会话值，请考虑以下语法。

示例：HttpContext.Session.SetString("login", "传入我们的值");

要在视图中获取会话值，请考虑以下语法。

示例：

  1. @using Microsoft.AspNetCore.Http
  2. @inject IHttpContextAccessor httpContextAccessor
  4. @httpContextAccessor.HttpContext.Session.GetString("login")
英文:

In .net core below way we can set & get session value.

For set session value please consider below syntax.

Example : HttpContext.Session.SetString("login", "pass our value");

For get session value inside view, please consider below syntax

Example:

@using Microsoft.AspNetCore.Http
@inject IHttpContextAccessor httpContextAccessor

@httpContextAccessor.HttpContext.Session.GetString("login")

huangapple
  • 本文由 发表于 2023年6月26日 03:01:15
  • 转载请务必保留本文链接：https://go.coder-hub.com/76552000.html
  • .net-7.0
  • asp.net-core-mvc
  • c#
  • model-view-controller
  • session
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定