I'm not a database guy but I need to design a database to store events for our application. Our client app connects to remote hardware and syncs count data. The count data are csv files split into ...
I just got following entities Employee, Client and Company. Where Employee and Client have one to many relationship with Company ie A single employee may be mapped to attend to many companies and ...
I am calling a web service from a CLR TVF in SQLServer 2008R2. On the IIS server this service has open permissions. When tested using GET or POST requests on a browser the web service works as ...
I'm not sure if this goes here or on Stack Overflow, but I figure someone here might know it. Why did the developers of LINQ decide that not only do you need ctx.InsertOnSubmit(item); but you also ...
I have a varbinary(max) column that I need to bulk import. The data I'm putting into this column is a byte in C#. How do I format the data in the comma-delimited file used for bulk import? In ...
Imagine a stream of data that is "bursty", i.e. it could have 10,000 events arrive very quickly, followed by nothing for a minute. Your expert advice: How can I write the C# insert code for SQL ...