Comments by Member 12586110 (Top 33 by date)

Hi Richard MacCutchan, Thank you for your response. I would like to save the json document to a drive for instance "C:\jsonDocs\weather.json"

Sure. Thank you.

Hi Mike Hankey, Thanks very much for your response. Could we accomplish the same using microsoft libraries.

Regards

Thank you Richard Deeming.

Hi Richard MacCutchan, Thank you for your response. I kind of hit a road block need help with how to proceed on write contents of a google sheet to the table and push data from table to google sheet. The code I put together takes me nowhere.

Thanks all for your response. I am still unable to covert json string as a custom .net object. I will keep working on it and keep you posted as I explore more.

Regards

Hi ZurdoDev, With return Ok("OK"); Get the Error: Cannot implicitly convert type 'Microsoft.AspNetCore.Mvc.OkObjectResult' to 'System.Threading.Tasks.Task' and
return BadRequest(ex.Message); Get Error: Cannot implicitly convert type 'Microsoft.AspNetCore.Mvc.BadRequestObjectResult' to 'System.Threading.Tasks.Task'. Thank you.

Hi ZurdoDev Thank you for your response. I am trying to read stream of data using StreamReader class and write the content to a database table as part of the post method. This approach used to work fine in .net 4.6 framework. When I write this I get exceptions when I use return and not able to import into a table. Could you please help or guide me write this in .net core 2.2.

Hi Mehul M Thakkar, Thanks very much for your response. Tried async Task and still get the same error.

Thanks Richard Deeming, I will work on it and keep you posted.

Hi Richard Deeming, Thanks very much for your response. I am running into errors at Request.Body HttpRequestMessage does not contain a definition for body. input.ReadLineAsync() The name input does not exist in the current context. Also how to use SqlBulkCopy with async.

Regards

Hi Gerry Schmitz, Thanks very much for your response. Could you please guide how do I make the message go directly from process to the client instead of async process.

Regards

Hi Afzaal Ahmad Zeeshan, Thanks very much for your response. I meant instead of waiting for the table insertion to complete, how to send a success response as soon as data stream is copied into memory and table insertion is done asynchronously.

Regards

Thanks very much.

Hi Richard Deeming, Would something like below be more appropriate.

public static byte[] streamToByteArray(Stream stream)
        {
			if (stream == null) throw new ArgumentNullException(nameof(stream));
			if (!stream.CanRead) throw new NotSupportedException("Cannot copy from a write-only stream.");
			using (MemoryStream ms = new MemoryStream())
			{
				stream.CopyTo(ms);
				return ms.ToArray();
			}
        }

Thank you for all the help.

Hi Richard Deeming, From what I understand what you say is keep the code as is with no error handling. Is that right?

Thank you.

Thank you @member33.

Thanks @member33 & @George Swan.

@member33, Could you please explain why can't AppSettings be used with static methods?

Thank you.

Hi Vincent Maverick Durano, Thanks for your response. For some reason I couldn't get your solution implemented as I was running into errors.

Please find my solution below and let me know your thoughts.

Startup.cs
Hide   Copy Code

        public IConfiguration Configuration { get; }        public void ConfigureServices(IServiceCollection services)        {            services.AddMvc();            services.AddSingleton<IConfiguration>(Configuration);        }

Controller.cs
Hide   Copy Code

        public MyController(IConfiguration configuration)        {            _configuration = configuration;        }	private void importdata(IList<string> lines)        {	    string connectionString = _configuration["SQLDB:SQLDBCONN:MySQLConnStr"];	}

Thank you.

Hi Vincent Maverick Durano, Thanks very much for your response. I made changes to ConfigureServices as below.

public void ConfigureServices(IServiceCollection services)
        {
            services.AddMvc();
            services.AddDbContext<ApplicationDbContext>(options => options.UseSqlServer(Configuration.GetConnectionString("SQLDB:SQLDBCONN:MySQLConnStr")));
        }

How do I call this connectionstring to dynamically change from the appsettings at runtime in the controller class?

string connectionString = ConfigurationManager.ConnectionStrings["SQLDBCONN"].ConnectionString;

When using this I get an error.

Error Message:

AddDbContext was called with configuration, but the context type 'ApplicationDbContext' only declares a parameterless constructor. This means that the configuration passed to AddDbContext will never be used. If configuration is passed to AddDbContext, then 'ApplicationDbContext' should declare a constructor that accepts a DbContextOptions<applicationdbcontext> and must pass it to the base constructor for DbContext.

Hi, Since I have the connectionstring "SchoolDBEntities" can I not just change the database server & database from the web.config file to the DbContext at the time of deployment?

public partial class SchoolDBEntities : DbContext
{
public SchoolDBEntities()
: base("name=SchoolDBEntities")
{
}
}

<connectionstrings>
<add name="SchoolDBEntities" connectionString="metadata=res://*/DevModel.csdl|res://*/DevModel.ssdl|res://*/DevModel.msl;provider=System.Data.SqlClient;provider connection string="data source=SQLSERVER\DEV;initial catalog=TestDB;user id=devuser;password=devpassword;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />

Hi, web.config file has the database connectionstring.

<connectionstrings>
<add name="mysqldb" connectionString="metadata=res://*/DevModel.csdl|res://*/DevModel.ssdl|res://*/DevModel.msl;provider=System.Data.SqlClient;provider connection string="data source=SQLSERVER\DEV;initial catalog=TestDB;user id=devuser;password=devpassword;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />


How do I make use of this in my code.

string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["mysqldb"].ConnectionString;

Hi, Could you please help me do it with code. I updated my original post accordingly. Thank you.

The table I have has varchar datatype on all the columns and no constarints. All the data I get is also text. I just want to handle exceptions if I were to run into problem records. Please help me.

Could you please help me capture failed records in SqlBulkCopy exception and write them to another table. All the fields in my table are of datatype varchar, but, just being cautious to handle these exceptions like below.

using (SqlCommand cmd = new SqlCommand("INSERT INTO [dbo].[log] ([ErrorRecord], [ErrorMessage]) VALUES (@ErrorRecord, @ErrorMessage)", sqlConnection))
{
cmd.Parameters.AddWithValue("@ErrorRecord", I.Id + ", " + I.Code + ", " + I.Description);
cmd.Parameters.AddWithValue("@ErrorMessage", ex.Message);
cmd.ExecuteNonQuery();
}

Thanks very much...I apologize for being so stupid. The '@' symbol did not catch my attention.

Hi, I wrote the below per your inputs but I have 2 issues.

1) How to split my string as the data is comma-separated the code below writes all the records into the ID field.
2) Could you please guide me on how to make the table inserts asynchronous, I will be calling the toTbl() from a different method.

	public string toTbl(IList < string > records)
        {
            const string connectionString = @"Data Source=dbsvr;Initial Catalog=dbname;User Id=usr;Password=pwd;";

            DataTable dt = new DataTable();
            dt.Columns.Add(new DataColumn("ID", typeof(string)));
            dt.Columns.Add(new DataColumn("Student", typeof(string)));
            dt.Columns.Add(new DataColumn("Grade", typeof(string)));
            foreach (string item in records.Skip(1))
            {
                dt.Rows.Add(new object[] { item });
            }

            using (var conn = new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlBulkCopy s = new SqlBulkCopy(conn))
                {
                    s.DestinationTableName = "Student";
                    s.BatchSize = dt.Rows.Count;
                    s.BulkCopyTimeout = 0;
                    s.ColumnMappings.Add("ID", "ID");
                    s.ColumnMappings.Add("Student", "Student");
                    s.ColumnMappings.Add("Grade", "Grade");
                    s.WriteToServer(dt);
                    s.Close();
                }
                conn.Close();
            }
        }
			
    

Thank you

Hi, I get two errors one at DataTable dt = lsttodt.ToDataTable(records); and others at await (await conn.OpenAsync();, await bulkCopy.WriteToServerAsync(dt);)

Error: CS0411, The type arguments for method 'ListtoDataTable.ToDataTable<t>(List<t>)' cannot be inferred from the usage. Try specifying the type arguments explicitly.
Error: CS4032, The 'await' operator can only be used within an async method. Consider marking this method with the 'async' modifier and changing its return type to 'Task<string>'.

Thanks