HYTOS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Configuration;

namespace ID2.Manager.Controller.Controllers

{

    public class BaseController

    {

        public string _DbConnectionStr = string.Empty;

        public BaseController()

        {

            this._DbConnectionStr = ConfigurationManager.ConnectionStrings["ID2Manager"].ToString();

        }

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using ID2.Manager.Data.Models;

using ID2.Manager.Dapper.Repository;

namespace ID2.Manager.Controller.Controllers

{

    public class UserController : BaseController

    {

        public UserInfo GetUserInfo(string userId, string userPW)

        {

            using (UserRepository rep = new UserRepository(this._DbConnectionStr))

            {

                return rep.GetUserInfo(userId, userPW);

            }

        }

    }

}

<?xml version="1.0" encoding="utf-8"?>

<Project ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">

  <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />

  <PropertyGroup>

    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>

    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>

    <ProjectGuid>{83DACC10-43B1-4E38-ABEF-E5EF9492A82D}</ProjectGuid>

    <OutputType>Library</OutputType>

    <AppDesignerFolder>Properties</AppDesignerFolder>

    <RootNamespace>ID2.Manager.Controller</RootNamespace>

    <AssemblyName>ID2.Manager.Controller</AssemblyName>

    <TargetFrameworkVersion>v4.8</TargetFrameworkVersion>

    <FileAlignment>512</FileAlignment>

    <Deterministic>true</Deterministic>

  </PropertyGroup>

  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">

    <DebugSymbols>true</DebugSymbols>

    <DebugType>full</DebugType>

    <Optimize>false</Optimize>

    <OutputPath>bin\Debug\</OutputPath>

    <DefineConstants>DEBUG;TRACE</DefineConstants>

    <ErrorReport>prompt</ErrorReport>

    <WarningLevel>4</WarningLevel>

  </PropertyGroup>

  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">

    <DebugType>pdbonly</DebugType>

    <Optimize>true</Optimize>

    <OutputPath>bin\Release\</OutputPath>

    <DefineConstants>TRACE</DefineConstants>

    <ErrorReport>prompt</ErrorReport>

    <WarningLevel>4</WarningLevel>

  </PropertyGroup>

  <ItemGroup>

    <Reference Include="System" />

    <Reference Include="System.Configuration" />

    <Reference Include="System.Core" />

    <Reference Include="System.Xml.Linq" />

    <Reference Include="System.Data.DataSetExtensions" />

    <Reference Include="Microsoft.CSharp" />

    <Reference Include="System.Data" />

    <Reference Include="System.Net.Http" />

    <Reference Include="System.Xml" />

  </ItemGroup>

  <ItemGroup>

    <Compile Include="Controllers\BaseController.cs" />

    <Compile Include="Controllers\UserController.cs" />

    <Compile Include="Properties\AssemblyInfo.cs" />

  </ItemGroup>

  <ItemGroup>

    <ProjectReference Include="..\ID2.Manager.Dapper\ID2.Manager.Dapper.csproj">

      <Project>{6d22aaa8-d584-43f4-b71c-b32c5c9288ed}</Project>

      <Name>ID2.Manager.Dapper</Name>

    </ProjectReference>

    <ProjectReference Include="..\ID2.Manager.Data\ID2.Manager.Data.csproj">

      <Project>{b17c0800-40f4-40e2-b5a6-d366d9c2e0f6}</Project>

      <Name>ID2.Manager.Data</Name>

    </ProjectReference>

  </ItemGroup>

  <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />

</Project>

using System.Reflection;

using System.Runtime.CompilerServices;

using System.Runtime.InteropServices;

// 어셈블리에 대한 일반 정보는 다음 특성 집합을 통해 

// 제어됩니다. 어셈블리와 관련된 정보를 수정하려면

// 이러한 특성 값을 변경하세요.

[assembly: AssemblyTitle("ID2.Manager.Controller")]

[assembly: AssemblyDescription("")]

[assembly: AssemblyConfiguration("")]

[assembly: AssemblyCompany("")]

[assembly: AssemblyProduct("ID2.Manager.Controller")]

[assembly: AssemblyCopyright("Copyright ©  2023")]

[assembly: AssemblyTrademark("")]

[assembly: AssemblyCulture("")]

// ComVisible을 false로 설정하면 이 어셈블리의 형식이 COM 구성 요소에 

// 표시되지 않습니다. COM에서 이 어셈블리의 형식에 액세스하려면

// 해당 형식에 대해 ComVisible 특성을 true로 설정하세요.

[assembly: ComVisible(false)]

// 이 프로젝트가 COM에 노출되는 경우 다음 GUID는 typelib의 ID를 나타냅니다.

[assembly: Guid("83dacc10-43b1-4e38-abef-e5ef9492a82d")]

// 어셈블리의 버전 정보는 다음 네 가지 값으로 구성됩니다.

//

//      주 버전

//      부 버전 

//      빌드 번호

//      수정 버전

//

// 모든 값을 지정하거나 아래와 같이 '*'를 사용하여 빌드 번호 및 수정 번호를

// 기본값으로 할 수 있습니다.

// [assembly: AssemblyVersion("1.0.*")]

[assembly: AssemblyVersion("1.0.0.0")]

[assembly: AssemblyFileVersion("1.0.0.0")]

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data.SqlClient;

namespace ID2.Manager.Dapper

{

    public interface IBaseRepository : IDisposable

    {

        SqlConnection DBConnection(string connectionStr);

    }

}

    <Reference Include="System.ComponentModel.DataAnnotations" />

    <Compile Include="IBaseRepository.cs" />

    <Compile Include="Repository\BaseRepository.cs" />

    <Compile Include="Repository\UserRepository.cs" />

  <ItemGroup />

  <ItemGroup>

    <ProjectReference Include="..\ID2.Manager.Data\ID2.Manager.Data.csproj">

      <Project>{b17c0800-40f4-40e2-b5a6-d366d9c2e0f6}</Project>

      <Name>ID2.Manager.Data</Name>

    </ProjectReference>

  </ItemGroup>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data;

using System.Data.SqlClient;

using System.ComponentModel.DataAnnotations.Schema;

using Dapper;

namespace ID2.Manager.Dapper.Repository

{

    public abstract class BaseRepository : IBaseRepository

    {

        private readonly IDbConnection _DbConnection;//readonly 삭제해야하는지 확인

        public SqlConnection DBConnection(string connectionStr)

        {

            return new SqlConnection(connectionStr);

        }

        public void Dispose()

        {

            if (this._DbConnection != null)

            {

                this._DbConnection.Close();

            }

        }

        protected BaseRepository(string connectionStr)

        {

            this._DbConnection = this.DBConnection(connectionStr);

            SqlMapper.TypeMapProvider = type =>

            {

                // create fallback default type map

                var fallback = new DefaultTypeMap(type);

                return new CustomPropertyTypeMap(type, (t, column) =>

                {

                    var property = t.GetProperties().FirstOrDefault(prop =>

                        prop.GetCustomAttributes(typeof(ColumnAttribute), true)

                            .Cast<ColumnAttribute>()

                            .Any(attr => attr.Name == column));

                    // if no property matched - fall back to default type map

                    if (property == null)

                    {

                        property = fallback.GetMember(column)?.Property;

                    }

                    return property;

                });

            };

        }

        public IEnumerable<T> Query<T>(string sql)

        {

            if (this._DbConnection.State != ConnectionState.Open)

            {

                this._DbConnection.Open();

            }

            return this._DbConnection.Query<T>(sql);

        }

        public IEnumerable<T> Query<T>(string sql, object param)

        {

            if (this._DbConnection.State != ConnectionState.Open)

            {

                this._DbConnection.Open();

            }

            return this._DbConnection.Query<T>(sql, param);

        }

        public async Task<IEnumerable<T>> QueryAsync<T>(string sql)

        {

            if (this._DbConnection.State != ConnectionState.Open)

            {

                this._DbConnection.Open();

            }

            return await this._DbConnection.QueryAsync<T>(sql);

        }

        public async Task<IEnumerable<T>> QueryAsync<T>(string sql, object param)

        {

            if (this._DbConnection.State != ConnectionState.Open)

            {

                this._DbConnection.Open();

            }

            return await this._DbConnection.QueryAsync<T>(sql, param);

        }

        public int Execute(string query, object param, IDbTransaction dbTran)

        {

            if (this._DbConnection.State != ConnectionState.Open)

            {

                this._DbConnection.Open();

            }

            return this._DbConnection.Execute(query, param, dbTran);

        }

        public async Task<int> ExecuteAsync(string query, object param, IDbTransaction dbTran)

        {

            if (this._DbConnection.State != ConnectionState.Open)

            {

                this._DbConnection.Open();

            }

            return await this._DbConnection.ExecuteAsync(query, param, dbTran);

        }

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using ID2.Manager.Data.Models;

namespace ID2.Manager.Dapper.Repository

{

    public class UserRepository : BaseRepository

    {

        public UserRepository(string connectionStr) : base(connectionStr) {}

        public UserInfo GetUserInfo(string userId, string userPW)

        {

            string query = $@"

select * from dbo.Users";

            return Query<UserInfo>(query, new { userId, userPW }).FirstOrDefault();

        }

    }

}

Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ID2.Manager.Controller", "ID2.Manager.Controller\ID2.Manager.Controller.csproj", "{83DACC10-43B1-4E38-ABEF-E5EF9492A82D}"

EndProject

		{83DACC10-43B1-4E38-ABEF-E5EF9492A82D}.Debug|Any CPU.ActiveCfg = Debug|Any CPU

		{83DACC10-43B1-4E38-ABEF-E5EF9492A82D}.Debug|Any CPU.Build.0 = Debug|Any CPU

		{83DACC10-43B1-4E38-ABEF-E5EF9492A82D}.Release|Any CPU.ActiveCfg = Release|Any CPU

		{83DACC10-43B1-4E38-ABEF-E5EF9492A82D}.Release|Any CPU.Build.0 = Release|Any CPU

	<connectionStrings>

		<add name="ID2Manager" providerName="System.Data.SqlClient" connectionString="data source=192.168.0.67;initial catalog=ARS;persist security info=True;user id=sa;password=dof1073#;multipleactiveresultsets=True"/>

	</connectionStrings>

using ID2.Manager.Controller.Controllers;

            UserController userService = new UserController();

            UserInfo info = userService.GetUserInfo(this.radTextBoxID.Text, this.radTextBoxPW.Text);

    <ProjectReference Include="..\ID2.Manager.Controller\ID2.Manager.Controller.csproj">

      <Project>{83dacc10-43b1-4e38-abef-e5ef9492a82d}</Project>

      <Name>ID2.Manager.Controller</Name>

    </ProjectReference>