Punica Posts - Answer Overflow

Punica

•Created by Punica on 12/8/2024 in #help

Problem with generating classes on Runtime and with Docker

Code: https://pastebin.com/mpRZQQWq Problem is I just have .yml file I make to .cs data in runtime. The Project ist running in a Docker Container but it create me the folder and files even on my system. I coud let it run 1 time since then I can not seem to build my container anymore. The Program always failes maybe someone has a idea

1 replies

CC#

•Created by Punica on 5/22/2024 in #help

SqlException without stopping or catching

Hello I get a Sql Exception in the following code when I connect to a MSSQL Server and make a Database. The Problem with it I can not catcvh the exception with my try block to see why that happening.

c#
        private static void CreateGenericDatabase(DataBaseConfig dbBaseConfig)
        {
            try
            {
                string connectionString = DatabaseConnectionGen.GetConnectionString(dbBaseConfig.SqlServerIp, dbBaseConfig.SqlType, dbBaseConfig.Username, dbBaseConfig.Password, dbBaseConfig.WindowsAuth, "CoreDb");

                using TestDbContext dbContext = DatabaseConnectionGen.GenerateBuilder(dbBaseConfig.SqlType, connectionString);
                dbContext.Database.EnsureCreated();
                using IDbContextTransaction transaction = dbContext.Database.BeginTransaction();
                dbContext.Database.Migrate();
                transaction.Commit();
            }
            catch(SqlException ex)
            {
                // Detaillierte Protokollierung der SqlException
                Debug.WriteLine("SQL Exception:");
                Debug.WriteLine($"Message: {ex.Message}");
                Debug.WriteLine($"Error Code: {ex.ErrorCode}");
                Debug.WriteLine($"Stack Trace: {ex.StackTrace}");
                if (ex.InnerException != null)
                {
                    Debug.WriteLine($"Inner Exception: {ex.InnerException.Message}");
                }
                
                throw;
            }
            catch (Exception ex)
            {
                // Detaillierte Protokollierung anderer Ausnahmen
                Debug.WriteLine("Exception:");
                Debug.WriteLine($"Message: {ex.Message}");
                Debug.WriteLine($"Stack Trace: {ex.StackTrace}");
                if (ex.InnerException != null)
                {
                    Debug.WriteLine($"Inner Exception: {ex.InnerException.Message}");
                }

                throw; // Re-throw the exception to propagate it further
            }
        }

c#
        private static void CreateGenericDatabase(DataBaseConfig dbBaseConfig)
        {
            try
            {
                string connectionString = DatabaseConnectionGen.GetConnectionString(dbBaseConfig.SqlServerIp, dbBaseConfig.SqlType, dbBaseConfig.Username, dbBaseConfig.Password, dbBaseConfig.WindowsAuth, "CoreDb");

                using TestDbContext dbContext = DatabaseConnectionGen.GenerateBuilder(dbBaseConfig.SqlType, connectionString);
                dbContext.Database.EnsureCreated();
                using IDbContextTransaction transaction = dbContext.Database.BeginTransaction();
                dbContext.Database.Migrate();
                transaction.Commit();
            }
            catch(SqlException ex)
            {
                // Detaillierte Protokollierung der SqlException
                Debug.WriteLine("SQL Exception:");
                Debug.WriteLine($"Message: {ex.Message}");
                Debug.WriteLine($"Error Code: {ex.ErrorCode}");
                Debug.WriteLine($"Stack Trace: {ex.StackTrace}");
                if (ex.InnerException != null)
                {
                    Debug.WriteLine($"Inner Exception: {ex.InnerException.Message}");
                }
                
                throw;
            }
            catch (Exception ex)
            {
                // Detaillierte Protokollierung anderer Ausnahmen
                Debug.WriteLine("Exception:");
                Debug.WriteLine($"Message: {ex.Message}");
                Debug.WriteLine($"Stack Trace: {ex.StackTrace}");
                if (ex.InnerException != null)
                {
                    Debug.WriteLine($"Inner Exception: {ex.InnerException.Message}");
                }

                throw; // Re-throw the exception to propagate it further
            }
        }

The connection string is fine and evrythings work as intended but I get in the output windows the following Exception. "Microsoft.Data.SqlClient.SqlException" in Microsoft.Data.SqlClient.dll and "Microsoft.Data.SqlClient.SqlException" in Microsoft.EntityFrameworkCore.Relational.dll

1 replies

Gaming

Programming