// @nuget: EntityFramework

// @nuget: Newtonsoft.Json

using System;

using System.Linq;

using System.Data.Entity;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations.Schema;

using System.IO;

using System.Runtime.Serialization.Formatters.Binary;

using System.Runtime.Serialization;

using Newtonsoft.Json;

​

//https://dotnetfiddle.net/9xJS3H

//https://dotnetfiddle.net/ZegyU4

public class Program

{

    //[STAThread]

    public static void Main()

    {

        //要序列化数据

        using (var ctx = new SchoolContext())

        {

            //添加种子数据

            SmsMessageModels s1 = new SmsMessageModels { Id=1, Name = "s1"};

            SmsMessageModels s2 = new SmsMessageModels { Id=2, Name = "s2"};

            ctx.SmsMessageModels.AddRange(new List<SmsMessageModels> { s1,s2});         

            ctx.SaveChanges();  

            WeChatTemplateSettings w1 = new WeChatTemplateSettings { Id=3, Name = "w1"};

            WeChatTemplateSettings w2 = new WeChatTemplateSettings { Id=4, Name = "w2"};

            ctx.WeChatTemplateSettings.AddRange(new List<WeChatTemplateSettings> { w1,w2}); 

            ctx.SaveChanges(); 

​

            MessagePushSettings m1 = new MessagePushSettings {Id=5, Name = "m1"};//短信

            MessagePushSettings m2 = new MessagePushSettings {Id=6, Name = "m2"};//微信

            ctx.MessagePushSettings.AddRange(new List<MessagePushSettings> { m1,m2});

            for(int i =3;i<=500;i++){

            ctx.MessagePushSettings.Add( new MessagePushSettings {Id=i, Name = "m"+i});

            }

            ctx.SaveChanges();

​

            //指定消息推送模板

            m1.SmsMessageModel = s1;

            m2.WeChatTemplateSetting = w2;

            ctx.SaveChanges(); 

​

            /*json序列化配置，解决循环依赖*/

            JsonSerializerSettings setting = new JsonSerializerSettings()

            {

                ReferenceLoopHandling = ReferenceLoopHandling.Ignore,

                Formatting = Formatting.None

            };

            //打印所有消息推送设置

            //Console.WriteLine(JsonConvert.SerializeObject(ctx.MessagePushSettings.ToList()));

​

        //二进制序列化到文件

        Serialize("DataFile.dat", ctx.MessagePushSettings.ToList());

        Console.WriteLine("序列化");

        //打印文件

        var s = ReadAllText("DataFile.dat");

        Console.WriteLine("大小："+s.Length+"字节");

        //Console.Write(s);

        Console.WriteLine();

        //从文件反序列化

        Console.WriteLine("反序列化");

        Deserialize();

        }

    }

    //二进制序列化到文件

    public static void Serialize(string fileName,object value)

    {       

        FileStream fs = new FileStream(fileName, FileMode.Create);

        BinaryFormatter formatter = new BinaryFormatter();

        try

        {

            formatter.Serialize(fs, value);

        }

        catch (SerializationException e)

        {

            Console.WriteLine("Failed to serialize. Reason: " + e.Message);

            throw;

        }

        finally

        {

            fs.Close();

        }

    }

    //写入文件

    public static void WriteFile(string path)

    {

        File.WriteAllText(path, ".NET Fiddle is AWESOME!!!");

    }

    //读取文件

    public static string ReadAllText(string path)

    {

        return File.ReadAllText(path);

    }

    //从文件反序列化

    static void Deserialize()

    {

        object value  = null;

        FileStream fs = new FileStream("DataFile.dat", FileMode.Open);

        try

        {

            BinaryFormatter formatter = new BinaryFormatter();

            value = (object) formatter.Deserialize(fs);

        }

        catch (SerializationException e)

        {

            Console.WriteLine("Failed to deserialize. Reason: " + e.Message);

            throw;

        }

        finally

        {

            fs.Close();

        }

        //打印反序列化结果

        string s1=JsonConvert.SerializeObject(value);

        Console.WriteLine("大小："+s1.Length+"字节");

        //Console.WriteLine(s1);

    }

}

​

​

public class SchoolContext: DbContext 

{

    public SchoolContext() : base(FiddleHelper.GetConnectionStringSqlServer()) // passed dotnetfiddle specific connction string

    {

    }

    public DbSet<MessagePushSettings> MessagePushSettings { get; set; }

    public DbSet<SmsMessageModels> SmsMessageModels { get; set; }

    public DbSet<WeChatTemplateSettings> WeChatTemplateSettings { get; set; }

}

[Serializable]//允许二进制序列化

public class MessagePushSettings

{

    public int Id { get; set; }

    public string Name { get; set; }

    //外键定义

    [ForeignKey("SmsMessageModel")]

    public int? SmsMessageModelId { get; set; }

    [ForeignKey("WeChatTemplateSetting")]

    public int? WeChatTemplateSettingsId { get; set; }

​

    //短信模板

    //[JsonIgnore]

    [InverseProperty("MessagePushSettings")]

    public SmsMessageModels SmsMessageModel { get; set; }

    //微信模板

    //[JsonIgnore]

    [InverseProperty("MessagePushSettings")]

    public WeChatTemplateSettings WeChatTemplateSetting { get; set; }

}

​

[Serializable]//允许二进制序列化

public class SmsMessageModels

{

    public int Id { get; set; }

    public string Name { get; set; }

​

        //消息推送

    [JsonIgnore]

    [InverseProperty("SmsMessageModel")]

    public ICollection<MessagePushSettings> MessagePushSettings { get; set; }

}

[Serializable]//允许二进制序列化

public class WeChatTemplateSettings

{

    public int Id { get; set; }

    public string Name { get; set; }

    //消息推送

    [JsonIgnore]

    [InverseProperty("WeChatTemplateSetting")]

    public ICollection<MessagePushSettings> MessagePushSettings { get; set; }

}