sql-server - 如何检查 Blazor Server 应用程序的数据库中是否存在用户输入？

Question

我正在使用登录创建一个 Blazor Server 项目，并且我想检查用户引入的电子邮件和密码是否存在于数据库中（我正在使用 Sql Server）。我在名为 BatranService 的类中创建了在数据库中搜索的方法，并在 Razor 组件中创建了登录表单，但我不确定连接这两者的代码会是什么样子。我会很感激任何帮助，谢谢！

     public class BatranService : IBatranService
    {
        private readonly VoluntariatDBContext _context;

        public BatranService(VoluntariatDBContext context)
        {
            _context = context;
        }

        public async Task<Batran> GetBatranByEmailAndParola(string email, string parola)
        {
            Batran batran = await _context.Batrans.Where(c=>c.Parola==parola).FirstOrDefaultAsync(c => c.Email == email);
            return batran;


        }
    }

    <EditForm Model="@batran" OnValidSubmit="@authBatran">
    <div class="container px-4 py-5 mx-auto">
        <div class="card card0">
            <div class="d-flex flex-lg-row flex-column-reverse">
                <div class="card card1">
                    <div class="row justify-content-center my-auto">
                        <div class="col-md-8 col-10 my-5">
                            <div class="row justify-content-center px-3 mb-3"> <img id="logo" src="css/autentificareLogo.png"> </div>
                            <h3 class="mb-5 text-center heading">Autentificare</h3>

                            <div class="form-group"> <label class="form-control-label text-muted">Email</label> <input type="text" id="email" @bind-value="@batran.Email" name="email" placeholder="Email" class="form-control"> </div>
                            <div class="form-group"> <label class="form-control-label text-muted">Parola</label> <input type="password" id="parola" @bind-value="@batran.Parola" name="parola" placeholder="Parola" class="form-control"> </div>
                            <div class="row justify-content-center my-3 px-3"> <button @onclick="authBatran" class="btn-block btn-color">Intra in cont</button> </div>
                            <div class="row justify-content-center my-2"> <a href="#"><small class="text-muted">Ai uitat parola?</small></a> </div>
                        </div>
                    </div>
                    <div class="bottom text-center mb-5">
                        <p href="#" class="sm-text mx-auto mb-3">Nu ai un cont?<button @onclick="deschideInregistrare" class="btn btn-white ml-2">Inregistreaza-te acum!</button></p>
                    </div>
                    <div class="col-12 row" style="text-align:left; font-weight:bold">
                        <span class="col-12"></span>
                    </div>
                </div>
                <div class="card card2">
                    <div class="my-auto mx-md-5 px-md-5 right">
                        <h4 class="text-white">We are more than just a company</h4> <small class="text-white">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</small>
                    </div>
                </div>
            </div>
        </div>
    </div>

</EditForm>

@code{

    private void authBatran()
        {

        }



}

标签： sql-serverblazor