Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I've had to do this on a couple of occasions. I originally used the ASP.Net template engine based on I think a Rick Strahl blog post. It worked but there was always some issue I was banging my head against.</p> <p>I switched to using the <a href="http://www.castleproject.org/others/nvelocity/index.html" rel="nofollow noreferrer">NVelocity</a> template engine and found it a really simple way to create and maintain email templates. There are a number of other template engines and I suspect next time I might have a serious look at the <a href="https://stackoverflow.com/questions/4368815/razor-views-as-email-templates">Razor</a> <a href="http://kazimanzurrashid.com/posts/use-razor-for-email-template-outside-asp-dot-net-mvc" rel="nofollow noreferrer">engine</a>.</p> <p>The code for merging values into the template:</p> <pre><code>private string Merge(ManualTypeEnum manualType, Object mergeValues) { var body = ""; var templateFile = string.Format("{0}MailTemplate.vm", manualType); var velocity = new VelocityEngine(); var props = new ExtendedProperties(); props.AddProperty("file.resource.loader.path", Config.EmailTemplatePath); velocity.Init(props); var template = velocity.GetTemplate(templateFile); var context = new VelocityContext(); context.Put("Change", mergeValues); using (var writer = new StringWriter()) { template.Merge(context, writer); body = writer.ToString(); } return body; } </code></pre> <p>The values to merge are passed as an anonymous object, and can include various types including lists etc e.g.</p> <pre><code>var emailBody = Merge(newDocument.ManualType, new { ManualType = newDocument.ManualType.ToString(), Message = change.Message, NewTitle = newDocument.Title ?? "", NewVersion = newDocument.Version ?? "", Contact = From, Changes = change.ToList(), }); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POWhat would be considered the best way to architect sending email from a C# web application?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USDavid Clarke
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COHmm.. Looks like I can do this with a file, but I may look at combining the Razor engine with the database, to get the information from a datarow, then transform it. What about separation of concerns? Do you think this would be mixing them too much?
      singulars
      1. PO
      1. UStostringtheory
    2. COIt's all about context. The app that uses the above code was old and crufty by the time I got to it and using a database to store templates would have been overkill for the volume/complexity of the emails being sent. Consider a template is just a string then you can store that string in a file or a database, whichever makes sense for your app. One of the benefits of using Razor templates is the Visual Studio support so you will get syntax colouring etc. If you store them in a database you are adding a couple of extra steps whenever you want to modify them, i.e. extract, change, update.
      singulars
      1. PO
      1. USDavid Clarke
    3. COVery true. However storing it in the database would probably end up being easier in my situation. I can of course have the file on my pc, and update db through code when needed. It takes forever to deploy a change to azure, and I would be hesitant to redeploy for only a small change such as that.
      singulars
      1. PO
      1. UStostringtheory
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload