Click here to Skip to main content
15,895,256 members
Articles / Programming Languages / SQL

SqlLinq: Taking LINQ to SQL in the Other Direction

Rate me:
Please Sign up or sign in to vote.
4.96/5 (50 votes)
12 Nov 2009CPOL13 min read 103.9K   1.1K   145  
Parsing SQL statements to create LINQ Expressions.
using System;
using System.IO;
using System.Xml;
using System.Text;
using System.Diagnostics;

namespace Kackman.Framework
{
    /// <summary>
    /// Summary description for FilePropertyBag.
    /// </summary>
    public class FilePropertyBag : XmlPropertyBag, ISaveablePropertyBag
    {
        private string m_filePath;

        public FilePropertyBag(string filePath)
        {
            m_filePath = filePath;

            if (Directory.Exists(Path.GetDirectoryName(m_filePath)) == false)
                Directory.CreateDirectory(Path.GetDirectoryName(m_filePath));

            if (File.Exists(m_filePath) == false)
                CreateBlank(m_filePath);

            try
            {
                Load(m_filePath);
            }
            catch (Exception e)
            {
                Trace.WriteLine(e.Message);
                Debug.Assert(false);

                // we are here because we tried to load the settings document and it didn't work
                // This can only be becuase the file got corrupted or something
                // so delete the current file and create a new blank one
                if (File.Exists(m_filePath))
                    File.Delete(m_filePath);

                CreateBlank(m_filePath);
                Load(m_filePath);
            }
        }

        public void Save(TextWriter writer)
        {
            writer.Write(this.ToString());
        }

        public void Save(Stream stream)
        {
            using (XmlTextWriter writer = new XmlTextWriter(stream, Encoding.UTF8))
            {
                writer.WriteRaw(this.ToString());
                writer.Flush();
            }
        }

        public void Save()
        {
            using (Stream stream = new FileStream(m_filePath, FileMode.Create, FileAccess.Write, FileShare.None))
                Save(stream);
        }

        private static void CreateBlank(string filePath)
        {
            using (StreamWriter writer = File.CreateText(filePath))
                writer.Write(string.Format("<?xml version='1.0'?><settings schemaVersion='{0}'/>", XmlPropertyBag.CurrentSchemaVersion));
        }
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Team Leader Starkey Laboratories
United States United States
The first computer program I ever wrote was in BASIC on a TRS-80 Model I and it looked something like:
10 PRINT "Don is cool"
20 GOTO 10

It only went downhill from there.

Hey look, I've got a blog

Comments and Discussions