oscript-library · nixel2007 · Aug 28, 2023 · Aug 11, 2023 · Aug 11, 2023 · Aug 12, 2023
diff --git a/.gitignore b/.gitignore
@@ -1,2 +1,5 @@
 bin
 obj
+/packages
+/.vs
+*.sqlite
diff --git a/oscript-sql/App.config b/oscript-sql/App.config
@@ -0,0 +1,26 @@
+<?xml version="1.0" encoding="utf-8"?>
+<configuration>
+  <configSections>
+    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
+  </configSections>
+  <entityFramework>
+    <providers>
+      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
+      <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
+    </providers>
+    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
+      <parameters>
+        <parameter value="v15.0" />
+      </parameters>
+    </defaultConnectionFactory>
+  </entityFramework>
+  <startup>
+    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8" />
+  </startup>
+  <system.data>
+    <DbProviderFactories>
+      <remove invariant="System.Data.SQLite.EF6" />
+      <add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />
+    <remove invariant="System.Data.SQLite" /><add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" /></DbProviderFactories>
+  </system.data>
+</configuration>
diff --git a/oscript-sql/DBConnector.cs b/oscript-sql/DBConnector.cs
@@ -1,12 +1,6 @@
 using ScriptEngine.Machine;
-using ScriptEngine.HostedScript.Library;
 
 using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Threading.Tasks;
-using System.Data.Sql;
 using ScriptEngine.Machine.Contexts;
 using System.Data.SqlClient;
 using System.Data.Common;
@@ -33,6 +27,9 @@ public class DBConnector : AutoContext<DBConnector>
         private string _connectionString;
         private string _lastErrorMessage;
 
+        /// <summary>
+        /// Создает новый экземпляр класса Соединение
+        /// </summary>
         public DBConnector()
         {
             _dbType = 0;
@@ -46,6 +43,7 @@ public DBConnector()
             _connection = null;
         }
 
+        /// <inheritdoc/>
         public override string ToString()
         {
             return "Соединение";
@@ -237,13 +235,10 @@ public string LastErrorMessage
             }
         }
 
-        public DbConnection Connection
-        {
-            get
-            {
-                return _connection;
-            }
-        }
+        /// <summary>
+        /// Соединение с БД
+        /// </summary>
+        public DbConnection Connection => _connection;
 
         /// <summary>
         /// Подготовленная строка соединения. В случае sqlite аналог ИмяБазы
@@ -263,6 +258,10 @@ public string ConnectionString
             }
         }
 
+        /// <summary>
+        /// Создать объект Соединение
+        /// </summary>
+        /// <returns>Соединение</returns>
         [ScriptConstructor]
         public static IRuntimeContextInstance Constructor()
         {
@@ -276,7 +275,7 @@ public static IRuntimeContextInstance Constructor()
         [ContextMethod("Открыть", "Open")]
         public bool Open()
         {
-            if (DbType == (new EnumDBType()).sqlite)
+            if (DbType == (new EnumDBType()).Sqlite)
             {
                 if (ConnectionString == string.Empty && DbName != string.Empty)
                     ConnectionString = string.Format("Data Source={0};", DbName);

diff --git a/oscript-sql/EnumDBType.cs b/oscript-sql/EnumDBType.cs
@@ -1,9 +1,4 @@
 using ScriptEngine.Machine.Contexts;
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Threading.Tasks;
 
 namespace OScriptSql
 {
@@ -13,29 +8,29 @@ namespace OScriptSql
     [ContextClass("ТипСУБД", "DBType")]
     public class EnumDBType : AutoContext<EnumDBType>
     {
+        /// <summary>
+        /// Тип базы данных SQLite
+        /// </summary>
         [ContextProperty("sqlite", "sqlite")]
-        public int sqlite
-        {
-            get { return 0; }
-        }
+        public int Sqlite => 0;
 
+        /// <summary>
+        /// Тип базы данных MSSQLServer
+        /// </summary>
         [ContextProperty("MSSQLServer", "MSSQLServer")]
-        public int MSSQLServer
-        {
-            get { return 1; }
-        }
+        public int MSSQLServer => 1;
 
+        /// <summary>
+        /// Тип базы данных MySQL
+        /// </summary>
         [ContextProperty("MySQL", "MySQL")]
-        public int MySQL
-        {
-            get { return 2; }
-        }
+        public int MySQL => 2;
 
+        /// <summary>
+        /// Тип базы данных PostgreSQL
+        /// </summary>
         [ContextProperty("PostgreSQL", "PostgreSQL")]
-        public int PostgreSQL
-        {
-            get { return 3; }
-        }
+        public int PostgreSQL => 3;
 
     }
 }
diff --git a/oscript-sql/IOScriptQuery.cs b/oscript-sql/IOScriptQuery.cs
@@ -1,11 +1,5 @@
-using ScriptEngine.Machine.Contexts;
-using ScriptEngine.Machine;
+using ScriptEngine.Machine;
 using ScriptEngine.HostedScript.Library;
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Threading.Tasks;
 
 namespace OScriptSql
 {

diff --git a/oscript-sql/QueryResult.cs b/oscript-sql/QueryResult.cs
@@ -1,15 +1,8 @@
-using System.Globalization;
-using ScriptEngine.Machine.Contexts;
+using ScriptEngine.Machine.Contexts;
 using ScriptEngine.HostedScript.Library.ValueTable;
 using ScriptEngine.Machine;
-using ScriptEngine.HostedScript.Library;
 
 using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Threading.Tasks;
-using System.Data.SQLite;
 using System.Data.Common;
 using ScriptEngine.HostedScript.Library.Binary;
 
@@ -24,11 +17,17 @@ public class QueryResult : AutoContext<QueryResult>
     {
         private DbDataReader _reader;
 
+        /// <summary>
+        /// Создает новый экземпляр класса РезультатЗапроса.
+        /// </summary>
         public QueryResult()
         {
         }
 
-
+        /// <summary>
+        /// Создает новый экземпляр класса РезультатЗапроса.
+        /// </summary>
+        /// <param name="reader">Чтение</param>
         public QueryResult(DbDataReader reader)
         {
             _reader = reader;