C#

Dave Kreskowiak wrote:

Where did you find this tutorial you're following?

Dave Kreskowiak wrote:

The problem with Linq-To-Sql is that it is a dead product and no longer under development.

dotnet ef migrations add AddCompanies
dotnet ef database update

Fezih5 wrote:

C#

PdfWriter pdfWriter = PdfWriter.GetInstance(document, new FileStream(path + originalFileName, FileMode.Append));

SELECT * FROM MyTable WHERE StreetAddress = 'Baker's Wood'

SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable;--'

SELECT * FROM MyTable WHERE StreetAddress = 'x';

DROP TABLE MyTable;

--'

StringBuilder sb = new StringBuilder("INSERT INTO table VALUES (");
foreach (object value in ((IDictionary<string, object>)rec).Values)
{
    if (command.Parameters.Count != 0) sb.Append(", ");
    string name = "@V" + command.Parameters.Count;
    command.Parameters.AddWithValue(name, value);
    sb.Append(name);
}
sb.Append(");");

command.CommandText = sb.ToString();

StringBuilder columnsList = new StringBuilder();
StringBuilder valuesList = new StringBuilder();
foreach (KeyValuePair<string, object> item in (IDictionary<string, object>)rec)
{
    if (columnsList.Length != 0) columnsList.Append(", ");
    if (valuesList.Length != 0) valuesList.Append(", ");
    
    string name = "@" + item.Key;
    command.Parameters.AddWithValue(name, item.Value);
    columnsList.Append(item.Key);
    valuesList.Append(name);
}

command.CommandText = "INSERT INTO table (" + columnsList + ") VALUES (" + valuesList + ");";

if (NameVar.Length > 12);